본문 바로가기

ETL Tools/Oracle Data Integrator

Direct load by interface with no work tables (C$, I$)

C$ & I$ tables을 사용하지 않고 Source to Target으로 바로 데이터를 적재하도록 구현하는 방법
no temp table(C$,I$) 

따라하기: http://s3.amazonaws.com/Ora/ODI-Simple_SELECT_and_INSERT-interface.swf
 

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.

Simple, fast and very clever!

Thank you for share your expertize Craig!

참조: http://odiexperts.com/direct-load-by-interface-with-no-work-tables