1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / jayasankarraju

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 is surrogate id ?

3 Answers   IBM,

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,




What are the methods for creating reusable transforamtions?

2 Answers  

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

Explain the different lookup methods used in informatica?

0 Answers  

How to join three sources using joiner?

0 Answers  

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

Explain the informatica workflow?

0 Answers  

For more Informatica Interview Questions Click Here
Categories