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
History Treatment Using Teradata API
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.