Hi all
I am getting a compilation error when i use a dynamic lookup with hash file
Compilation Error : Job contains cyclic or linear dependendiews and will not run.
Any help on Compilation error.
Abhi
Dynamic Look up using Has File Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
-
- Participant
- Posts: 40
- Joined: Tue May 18, 2004 10:51 pm
Hi Abhinav,
I beleive what you are doing is updating the same hash file, I mean
try this design
Hope this helps
James
I beleive what you are doing is updating the same hash file, I mean
try this design
if this doesn't work then you will have to use two transforms, first one look-ups the Hash A and the second one updates Hash A and then the TargetHash A
|
|
V
SRC--------------------------->XFM------------------>TGT
|
|
|
V
Hash A
Hope this helps
James
-
- Participant
- Posts: 5
- Joined: Sat Jun 19, 2004 9:55 am
Jamesvanam wrote:Hi Abhinav,
I beleive what you are doing is updating the same hash file, I mean
try this design
if this doesn't work then you will have to use two transforms, first one look-ups the Hash A and the second one updates Hash A and then the TargetHash A
|
|
V
SRC--------------------------->XFM------------------>TGT
|
|
|
V
Hash A
Hope this helps
James
I got the dynamic lookup part working, but the problem is the column which i have in my lookup from srce is the unique key and when i have the duplicates in it .
The lookup doesnt accept the duplicates as the prinmary key for the Hsh fiel is the same column which is a unique key column for the source.
if i use the Stage Variable i am able to get the cloumn changed to -1 for one of my columns in tgt which indicates that its a void record as a record already exists with the same unique column .
what i need to do is i need to copy forward the record which is repeated in my source and change the column to -1 indicating that this record is a void one. and the latest record would be set to 1.
Any help on this would be great.
Thanks
Abhi