initial load
Posted: Wed Mar 08, 2006 7:55 am
Hi,
I am trying to do an initial load into Oracle table.
For this I created a hashed file with 2 fields--Timestamp and a Dummy field(as a key column). I am looking up on this hashed file with my source table and checking it against the last updated date in my source table. If source.lastupdated >= hashedfile.lastupdated, I will then extract the data. I am giving this above condition as a constraint in the Transformer. Now when i run the job to make an initial load, the data is not coming out of the Transformer though its going in. I am assuming this is because theres no value in the hashed field for the lastupdated column initially. Is there a way I can achieve this. Am I misssing out some thing. Also I would like to know if there is a better way to do it.
However, its working fine if I am doing incremental loading.
Thanks
Kris.
I am trying to do an initial load into Oracle table.
For this I created a hashed file with 2 fields--Timestamp and a Dummy field(as a key column). I am looking up on this hashed file with my source table and checking it against the last updated date in my source table. If source.lastupdated >= hashedfile.lastupdated, I will then extract the data. I am giving this above condition as a constraint in the Transformer. Now when i run the job to make an initial load, the data is not coming out of the Transformer though its going in. I am assuming this is because theres no value in the hashed field for the lastupdated column initially. Is there a way I can achieve this. Am I misssing out some thing. Also I would like to know if there is a better way to do it.
However, its working fine if I am doing incremental loading.
Thanks
Kris.