Skip to Main Content
Forums

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!

Odi file to Table

Rookie_86Dec 19 2016 — edited Jan 11 2017

Hi gurus,

I'm using ODI 12c.

I have a file with 1 Million records which i'm suppose to load the same to table.

file - table mapping.

What kind of KM will help to load data without any performance issues ?

I used - LKM File to SQL, and IKM: Sql control append. (Truncate true)

I also used - LKM File to SQL, and IKM: oracle insert with truncate . true.

But, it ddnt helped me to load the data quickly it is taking long time.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2017
Added on Dec 19 2016
#business-intelligence-applications, #data-integrator, #system-management-and-integration
7 comments
1,679 views