Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24560 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / g. manthiramoorthy
1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by lookup transformation? Explain the types of lookup transformation?
Is it possible to create multiple domains on a single Informatica server?
how tokens will generate?
How to elaborate powercenter integration service?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can repository reports be accessed without sql or other transformations?
What is a repository manager?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are batches?
How can you define user defied event?
What the difference is between a database, a data warehouse and a data mart?
What is a snowflake schema?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
