I'm loading T14 and I need to do a initial load and loads after that, Like when I run it first time I don't have any records in the table T14. and The Constraint in the Transformer is : T14.Column1 <> Src_ORA.Column3 then load that record. and also I've a foreign key in T14 which is Primary key in T13 and was wondering if these could loaded in the same job.LKP_For_T14
|
|
|
Src_ORA --------------> XFM---------->T14
right now I've two jobs, First one loads T13 then I load the T14.
how can I do this. Please help me.
Regards
James