Job Gets into a HANG State
Posted: Thu Jul 15, 2004 11:01 pm
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
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