Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rekha
LOOK UP IS A PASSIVE TRANSFORMATION.
LOOK UP IS USED TO LOOK UP THE DATA IN RELATIONAL TABLES
FLAT FILES ,VIEWS OR SYNONYMS
LOOK UP IS USED TO 1 GET A RELATED VALUE
2 PERFORMING CALCULATIONS
3. UPDATING SLOWLY CHANGING DIMENSIONS
TYPES OF LOOK UP
CONNECTED
UNCONNECTED
CACHED/UNCACHED
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is Session and Batches?
What differs when we choose the sorted input for aggregator transformation?
What are the different options available for update strategy?
How to generate sequence numbers?
What is data caches/ index caches?
How do you handle two sessions in Informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can anyone tell me the new features in Informatica 9 Version?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a filter transformation?
Why update strategy and union transformations are active?
How do you migrate data from one environment to another?
Write the unconnected lookup syntax and how to return more than one column.
Explain lookup transformation is active in informatica
