Dynamic Look up using Has File Stage

[Abhinav]

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

[sumitgulati]

I think there is a flaw with the job design. You probably are forming a loop between stages. Just insert a static stage (say a hash file) between two of your active stages and then try compiling.

Regards,
Sumit

[Jamesvanam]

Hi Abhinav,
I beleive what you are doing is updating the same hash file, I mean

try this design

Hash A
|
|
V
SRC--------------------------->XFM------------------>TGT
|
|
|
V
Hash A

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 Target

Hope this helps
James

[VamshiReddy]

Hi Abhinav,
I beleive what you are doing is updating the same hash file, I mean

try this design

Hash A
|
|
V
SRC--------------------------->XFM------------------>TGT
|
|
|
V
Hash A

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 Target

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