i have 2 mapings for this 2 mapings i want use only one
lookupt/r how?

Answers were Sorted based on User's Feedback



i have 2 mapings for this 2 mapings i want use only one lookupt/r how?..

Answer / lvpr

If the lookup condition is same for both mappings, then
make lookup t/r as reusable t/r

Is This Answer Correct ?    18 Yes 0 No

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?..

Answer / sathish

create lookup using transformation developer then you can reuse same lookup in any times

Is This Answer Correct ?    6 Yes 0 No

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?..

Answer / usha

we can reuse the LKP in different mapping...

wat we need to do is..

step1:--create a LKP in transformation designer..

if we cerate a transformation in transformation developer
its reusable...

step2:-- create a transformation ...click--->transformation
tab--->changeto reusable

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the join types in joiner transformation?

1 Answers   Informatica,


explain about session partitions ?

1 Answers  


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,






source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,


Kimball and Inmon methodologies?

2 Answers  


what is the difference between lookupoveride and joiner?

3 Answers  


What are the active and passive transforamtions?

2 Answers  


Categories