Insert and Update
Posted: Mon Apr 10, 2006 1:10 pm
Hi D.S Gurus,
Below is the job structure,Im performing.In this Job, the data is loaded in to a table X.Using that table as source, I'm making a lookup with the help of a hashed file(part of the data from table X is sent to this hashed file for look up) in the transformer 2.
In transformer 2, I make a look up and update the same table X.So the source and target are the same table.In first case, the data is being inserted and after that Im updating part of columns which are inserted.When I run this job, the job is stucking up with no indication of any error.
Transformer1------>Hashed File
| |
| |
| |
Data-->Source---------->Transformer2------------>Target[/img]
Please mail me your opinion to solve this problem.Your help in this matter is greatly appreciated.
Thanks,
V.V.G[/img]
Below is the job structure,Im performing.In this Job, the data is loaded in to a table X.Using that table as source, I'm making a lookup with the help of a hashed file(part of the data from table X is sent to this hashed file for look up) in the transformer 2.
In transformer 2, I make a look up and update the same table X.So the source and target are the same table.In first case, the data is being inserted and after that Im updating part of columns which are inserted.When I run this job, the job is stucking up with no indication of any error.
Transformer1------>Hashed File
| |
| |
| |
Data-->Source---------->Transformer2------------>Target[/img]
Please mail me your opinion to solve this problem.Your help in this matter is greatly appreciated.
Thanks,
V.V.G[/img]