i have 2 mapings for this 2 mapings i want use only one
lookupt/r how?
Answers were Sorted based on User's Feedback
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 |
Answer / sathish
create lookup using transformation developer then you can reuse same lookup in any times
| Is This Answer Correct ? | 6 Yes | 0 No |
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 |
Make a note of the quantity vaults made in informatica?
whatis the default data driven operation in informatica
What is a mapplet/worklet in informatica?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Target is zero file and how can you send the email?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
All active transformations r passive or not?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
how DTM buffer size and buffer block size are related
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,