DSXchange

Is it possible to do Type 2 History Treatment using single Teradata API.
In case of type 2 if the new record comes ,you are suppose to close the previous record and insert the new record.So both records will be there in table one with close End_Date and another with open End_Date.

This scenario I am able to meet using two jobs.In one I am inserting all the jobs and in another I am updating and calling the jobs in a sequential manner.

But is it possible to meet using single job and single Teradata API.


Regards
Gaurav

Welcome aboard. :D

The short answer is YES.

Techniques can be found by searching the forum (perhaps use Type 2 and SCD (slowly changing dimension) as search terms).