ODI 12c Tutorial Lesson7 First Mapping with example on Oracle SQL to SQL

ODI 12c Tutorial Lesson7 First Mapping with example on Oracle SQL to SQL
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners

[@indusekharreddy3941]

Very nice explanation bro..really a great work..!!

[@ayseak_]

I created target table in model, but that is not yet created in my target database, so I want to create the table on runtime. For that, I clicked on CREATE TARGET TABLE in IKM while creating mapping. When I run scenario I get error 'table or view does not exist'? What might be the problem?

[@barunkumarsingh1862]

While doing the mapping getting following error: 1. ODI-1228: Task Insert new rows-IKM Oracle Insert-Load STG_EMP_MAPP fails on the target connection DS_TDEV_TGT. Caused By: java.sql.SQLSyntaxErrorException: ORA-02019: connection description for remote database not found. and when try to change LKM and IKM as per the video, stilll getting this error. ODI-1228: Task Insert new rows-LKM SQL to SQL (Built-In)-Load EXPRESSION_AP fails on the target connection DS_TDEV_TGT. Caused By: java.sql.BatchUpdateException: ORA-00942: table or view does not exist Please help... Thanks in Advance!!!

[@mohammadanasshaikh8050]

Which kind of error it will avoid when you select remove temporary object on error

[@Ganeshay-996]

make sure ur voice will be good when you gonna make new videos

[@singamsanjay3934]

can we use SQL query as source in ODI mapping?

[@BenjaminTua]

Good question Singam. Did you get an answer to this?