Avoiding Multiple Lookup
Moderators: chulett, rschirm, roy
Avoiding Multiple Lookup
Hi , I am running a job which requires me to do multiple lookups on the same table for each record.
I know in Informatica i could do an unconnected Lookup and call it for each column..Being new to DS environ still trying to figure out a better way.
The situation I am talking about is
ColumnA ColumnB ColumnC ColumnD ColumnE
1 A B C D
ANd Lookup Table is
ColumnA ColumnB
A XXX
B YYY
c ZZZ
D MMM
and the output I want is
1 XXX YYY ZZZ MMM
I dont want to do a Join as I may loose records using the JOin Stage.
Please suggest a better way to do it.
I know in Informatica i could do an unconnected Lookup and call it for each column..Being new to DS environ still trying to figure out a better way.
The situation I am talking about is
ColumnA ColumnB ColumnC ColumnD ColumnE
1 A B C D
ANd Lookup Table is
ColumnA ColumnB
A XXX
B YYY
c ZZZ
D MMM
and the output I want is
1 XXX YYY ZZZ MMM
I dont want to do a Join as I may loose records using the JOin Stage.
Please suggest a better way to do it.
Does this need to be a PX job? There's an equivalent to the unconnected lookup on the Server side, hence the question. Not saying there isn't a PX answer to this, but nothing is popping into my head at the moment other than the Server solution.
Out of curiousity, what 8.x version do you have?
Out of curiousity, what 8.x version do you have?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
Re: Avoiding Multiple Lookup
Why do you lose records by using a Join Stage? Please Explain.ashishm wrote:I dont want to do a Join as I may loose records using the JOin Stage.
Please suggest a better way to do it.
Prakash Dasika
ETL Consultant
Sydney
Australia
ETL Consultant
Sydney
Australia