How to Create First Mapping in ODI - ODI - Oracle Data Integrator Tutorial - Session - 5

[@Jasminbird]

This is very helpful!! Thanks a lot

[@srichandrasekhar4352]

sri, can u tell me how did u create model scott and new model scott?

[@ashirwadmishra]

Hi Sir, I am trying to map a source Oracle table with target oracle table. However, source oracle table contains xml data in a clob format and target table contains xml elements as columns. So to map each attribute I used predefined odi function EXTRACT(,) within expression builder. For Ex : EXTRACT(XMLTYPE(XML_DATA),’//tag1/tag2/tag3/tag4/tag5/tag6/text()’) . However my xml contains multiple tag6 whose value I am trying to fetch . when using this function I am able to load the value present in tag6 to the target table. However, it is picking all the tag6 values and are appending them. Could you please tell me how to get the separate values to be inserted into the target table. I serach few links and got to know that we can use XMLSEQUENCE . but not sure how to use that. Could you please shed some light so that I can achieve the desired result. Many thanks for your help in advance.