Hi friends…
I got this video from Craig Stewart that shows us how to direct load data from source to target with no work (C$ and I$) table use.
http://s3.amazonaws.com/Ora/ODI-Simple_SELECT_and_INSERT-interface.swf
Simple, fast and very clever!
Thank you for share your expertize Craig!
December 10, 2017 at 11:24 AM
How do i find C$, I$ and E$ tables?
August 13, 2015 at 8:43 AM
IKM SQL to SQL append not present in 11.1.1.7. need help.
May 20, 2015 at 10:24 AM
Hi,
I am trying to direct load in my ODI interface without work tables (C$ and I$). I am using ODI version 11.1.1.7.
I am not able to find out Staging area : MYSQL:MYSQL Source
and
Not able to find out IKM SQL to SQL append
Is it not possible in ODI version 11.1.1.7 or should I need to import any IKM or any drivers to achive this requirement.
Please help me on this.
June 15, 2014 at 7:12 AM
Hi ,
I have a requirement wherein I need to avoid C$ and I$. But in my case, I have fetch/extract data from many tables and I don’t want to create staging in Source db as my source application is a web commerce portal and the portal team does not recommend to create staging area on an OLTP db as it might have a un-nesessary IO. The interface will run on a daily basis and it will extract around 200 thousand records.
Do you know if there is any other way of bypassing I$ and C$.
June 16, 2014 at 2:59 PM
Hi,
it’s a simple KM customization where you alter the “target” in the LKM to be the “real” target and, for IKM kill all steps.
BUT, it’ll work only if you have every single data transformation, filters or joins mapped to be executed at source.
Let me know if works and thank you for visit us!
June 17, 2014 at 2:10 AM
Hi.
Sorry, I didn’t understand what you mean by customizing the KLM to a “real” target. Can you pls give an example.
Since my source area has tables from different data servers, I don’t think we can bypass C$table. Correct? Please do let me know.
March 3, 2017 at 1:58 PM
Hi can any one help me.. I have to load data into target table from flat life. I will removed all steps in km and hard coded load data with insert statement.. But my file data as to converted into timestamp any1 can help
March 27, 2014 at 8:13 AM
Hi ,
I have tried with SQL Server (source database) to Oracle (target database) and Oracle (source database) to Oracle (target database) but in flow tab we should select LKM also or else while saving the interface it is showing error pop up box.
Could you please suggest me to avoid the C$ table or how to get bulk data from source database instead of 30 records every time.
ODI installed on Oracle 10g.
Thanks and Regards,
Shaik.
June 16, 2014 at 3:06 PM
Hi,
the amount of data that is fetched from some connection is controlled in the correspondent Data Server (Topology). You can change it over there.
About the Bulk SQL, if you have distinct databases instances as source and target unless it possible to build some kind of “bridge” (DBLink, External Table, etc) it’s necessary go thru some text files to get a fast integration. But if a bridge is possible, then is just indicate it at ODI and use the right LKM.
Make sense?
Thank you for visit us!
April 6, 2011 at 9:38 AM
Raul can you be more specific on how to modify “generate ctl ” step.
Thanks
February 11, 2011 at 10:16 PM
hi, i was use another method.
working with sql loader integrated feature, (file to oracle), i modified the lkm specific “generate ctl ” step , i change odi variable to load data directly to target table rather than temp c$ table.
October 10, 2013 at 3:05 AM
Hi Raul,
Can you please explain specifically how to modify “generate ctl ”. It help me so much.
Thanks
October 10, 2013 at 4:56 PM
what kind of changes are you looking for ?
December 4, 2010 at 4:12 AM
Yes indeed, this has always been available, it is just one of those “you gotta know it to use it!” things.
I hope you found this useful.
December 3, 2010 at 7:04 AM
Is it working only in ODI 11g or is it possible in 10g also ?