Hi All,
We are developing a Job that will take care of SCD Type-2. First let me explain how we are implementing the same.
1.Data Extracted from Source using Teradata Access Plug-In
2.We then look up the Target table and basing upon the constraint and look up we Update or Insert the Target table in two separate links through Teradata Access Plug-In.
..................|Look Up of Target Table|
.........................|
|Source|------>|Tran|---------->|Update Target|
..............................| ---------->|Insert Target|
When we have records for both Update and Insert the job gets into a Hanging State. Initially we tried the Look Up through Teradata Access Stage, but We tried putting the Look Up in HASH also and we get the same problem.
Please suggest.
Thanks in Advance
Job Gets into a HANG State
Moderators: chulett, rschirm, roy
This happens basically becos of the locks in database. The best practise is to split the two stream (insert/update) separate and then do the inserts or updates. If you want this to happen in the same job then send the target to text file and then use the same text file and do your inserts and updates. This will work in the same job.
Cheers
Rasi
Cheers
Rasi