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]
Insert and Update
Moderators: chulett, rschirm, roy
Re: Insert and Update
Vardhan,
I did not understand a word that you were trying convey. To make this worse, your diagram added to your verbal confusion. I am lost . Please use the CODE tags in the editor if you are drawing your design, or the IMG tags properly in case you have your image hosted elsewhere.
gateleys
I did not understand a word that you were trying convey. To make this worse, your diagram added to your verbal confusion. I am lost . Please use the CODE tags in the editor if you are drawing your design, or the IMG tags properly in case you have your image hosted elsewhere.
gateleys
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need separate Hashed File stages - one for lookups, one for writing - even though they refer to the same hashed file. Put an annotation on your design canvas to alert future developers to the fact that both stages refer to the same hashed file.
Code: Select all
HFStage1 HFStage2
| ^
| |
V |
---> TransformerStage --->
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.