Hi
One of my job I am loading data from ODS source to Target Staging table with Truncate Load option.
1st Job I have created oracle Connector Stage with very big user defined query and then Transformer stage and load into final Target ORACLE Enterprise stage.
Oracle Connector stage --> Transformer Stage --> Oracle Enterprise Stage.
This job works fine.
Job2: I have removed Transformer stage directly connected to oracle Connector stage to Oracle Enterprise stage.
Oracle Connector stage --> Oracle Enterprise stage.
The job 2 is running but it is not reading any row.
I hope we have to use one active stage between any two passive stages.
Thanks
Man
Oracle Connector stage direct to Oracle Target Ent Stage
Moderators: chulett, rschirm, roy
I found many years ago when truncating/loading into Oracle, it performs significantly better to fully land the data locally to disk in a first job, and perform the truncate/load separately in a second job. Try breaking your job into two, using a Data Set stage as job1 target and job2 source. If you're not needing any Transformer stage functionality then leave it out.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore