How the dynamic lookup is Achieved in Data Stage
Moderators: chulett, rschirm, roy
How the dynamic lookup is Achieved in Data Stage
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 DS.
Regards,
Shiva.
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 DS.
Regards,
Shiva.
-
- Participant
- Posts: 34
- Joined: Fri Sep 22, 2006 10:59 pm
- Location: India
-
- Participant
- Posts: 34
- Joined: Fri Sep 22, 2006 10:59 pm
- Location: India
Shiva,
Your jobe design should look like this:
Each time Datastage will load all the TGT_TBL contents to Hashfile first and then Src_Tbl will do lookup on that hash file.
Your jobe design should look like this:
Code: Select all
TGT_TBL--------------->Hashfile
|
|
|
Src_Tbl------------------->Transformer----------->TGT_TBL
Regards,
Balaji.
Balaji.
Before you start any design you have to analyze what you want.
Sometimes a Sort may help for not need to have a permanent commit.
For to use a Hashfile with commit use an Universe Stage and set commit to 1.
But what is best for your job can only be said when we know more about it.
Sometimes a Sort may help for not need to have a permanent commit.
For to use a Hashfile with commit use an Universe Stage and set commit to 1.
But what is best for your job can only be said when we know more about it.
Wolfgang Hürter
Amsterdam
Amsterdam
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 time
101,Siva,10000 -will be inserted
Second time
101,Siva,9000 -Should be updated... by looking the Target table itself....
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 time
101,Siva,10000 -will be inserted
Second time
101,Siva,9000 -Should be updated... by looking the Target table itself....