Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

merging 3 different tables in one csv file in ODI

abf2a2f7-8575-4711-91ee-422d6966353fNov 5 2016 — edited Nov 7 2016

hi ,

i am new to odi and i have a question into it,

i am currently mapping 3 tables that will merge and go to one target csv file but my problem is that 3 tables doesnt have same fields to join up at each tables. my sql command for that 3 tables is

select * from header,detail, trailer and the result was merging those 3 tables into one table. how could i do this in ODI

Thanks,

Justin

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2016

Added on Nov 5 2016

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

301 views