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
Can we get 1st record through Informatica(without sequence number).
Explain the different kinds of facts.
What are the different clients of powercenter?
What is the difference between a repository server and a powerhouse?
Please let me know how to make Data masking in informatica..
What is a snowflake schema?
Define pmcmd command?
Briefly describe lookup transformation?
tell me about your project functionality
What are the various types of transformation?
Define the various join types of joiner transformation?
What are ETL Tools?
What do you mean by channel change?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How can we update a record in the target table without using update strategy?
