Implementing SCD2 functionality the old fashioned way!!
Posted: Tue Jun 22, 2010 5:19 pm
I modified the job and implemented SCD2 in the old fashion way not using the SCD stage provided datastage. Below is the functionility:
- if a new record is found it inserts
- if an existing record is found, it end dates the existing record in the DIM and
- and open a new record .
So, the job has 2 inserts and 1 update Oracle stage. The issue I am facing with this is if I just have 1 Insert and 1 update and send the other insert to a Peek or file, it runs OK. But, if I add all three Oracle stages in the TGT, then it hangs and doesnt progress.
For now, I am doing the 3rd insert into a flat file and then dumping it to the table in a different job.
Is there something that I am missing. Thanks,
- if a new record is found it inserts
- if an existing record is found, it end dates the existing record in the DIM and
- and open a new record .
So, the job has 2 inserts and 1 update Oracle stage. The issue I am facing with this is if I just have 1 Insert and 1 update and send the other insert to a Peek or file, it runs OK. But, if I add all three Oracle stages in the TGT, then it hangs and doesnt progress.
For now, I am doing the 3rd insert into a flat file and then dumping it to the table in a different job.
Is there something that I am missing. Thanks,