hegde

• Feb 21st, 2007

 

can u pls clarify ur ques?

karthumyl

 Profile Answers by karthumyl Questions by karthumyl

• Feb 21st, 2007

 

Is there any transformation that could do the function of a lookup transformation. or Is there any transformation that we can use instead of lookup transformation.

Noel Lastra

 Profile 

• Feb 21st, 2007

 

question is misleading ...  do you mean look up transformation will become obsolete since new transformation is created to do same thing in a better way ? which version ?

Vicky

• Feb 22nd, 2007

 

Yes Joiner with Source outer Join and Stored Procedure can replace look-up transformation

Latcha Babu

• Feb 27th, 2007

 

You can use Joiner transformation instead of lookup, look up is only for relational tables
which are not sources in your source analyzer but by using joiner we can join relational and flat files, relational sources on different platforms.

sanghala

 Profile Answers by sanghala Questions by sanghala

• Mar 1st, 2007

 

Vicky,

Can you please Validate your answer with some example ??

surendra.kumar

• Mar 2nd, 2007

 

Hi,
Actually by look up t/s we are looking the required fields in the target and comparing with source ports..
Without look up we can do by joiner

Master outer joiner means, Matched rows of both t/s and unmatched from master table..

So you can get all changes..

if any doubt reply me back.. i will give another general example to you

shanthi1

 Profile Answers by shanthi1 

• Mar 18th, 2007

 

plz don't mislead.........


A master outer join keeps all rows of data from the detail source and the matching rows from the master source. It discards the unmatched rows from the master source.

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

 

I hope The Joiner transformation is only for join the hetrogeneous sources.For Eg,when we use one source from Flat file and another one is from Relational.I have a question as "How Joiner transformation overrides the Lookup" however both transformation performs different actions.

Cheers

Thana

sathishk2k

 Profile Answers by sathishk2k 

• May 22nd, 2008

 

Lookup is nothing but Outer Join. So Look up t/s can be easily replaced by a joiner in any tool.

xgeneration

 Profile Answers by xgeneration 

• May 25th, 2008

 

as u mensioned that a joiner transformation can be used to work out the functionality that of look-up using master outer join,but what if the source is from different database & source from dff database.then how would u create a join.

so i think that there's no transformation that replay's a look-up transformation functionality for what it's been mensioned.

srinivas.j.abinitio

 Profile Answers by srinivas.j.abinitio 

• Jul 1st, 2011

 

Hi ,

Look up transformation does not replaces with using joiner transformation.

because joiner return multiple matching values but look up can't return multiple matching values(look up policy multiple match  use----last or first ) values only.

we can Replace look up as a source Qualifier transformation only.

Thanks&Regards,

srinivas.juluri