DSXchange

I got correct o/p using stage variables...

So try to implement using Kumar's logic.....

o.k thank you wolf...

If I get like that scenario I will post the query :D

I have given just an example......this will work fine....
But this will not work as Informatica's Dynamic lookup...
Any other solution..... Wolf

I think Balaji you are talking about static lookup.... Gerling, My requirement is as follows i/p- Sequential file: eno,ename,sal 101,Siva,10000 102,Prem,2000 101,Siva,9000 o/p- Table: 101,Siva,9000 102,Prem,2000 Since the duplicate records are coming in the same file with different values, First tim...

Can you pls explain with an example?....

But will this refresh the hash file as soon as my target table is updated?.....

Hi All, Can you please explain me, how the dynamic lookup in Informatica can be achieved in Data Satge Server Edition... For those who don't know Informatica, I have a Target Table TGT_TBL. I want to have a lookup against this itself while loading the data into TGT_TBL. How this could be achieved In...

Try to pass the hash file names using job parameters.....

i.e....for each instance you pass the different hash name....

Rgds,
Shiva....

Use pivot Stage in Designer.....


Regards,
Siva.

Try to partition the target table and then bulk load it will improve performance...... Otherwise Create indexes in the target table.....

Regards,
Siva.