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
Explain in detail scd type 2 through mapping.
What is the difference between stop and abort in informatica
Can we create multiple integration service on single repository?
Why do we need informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do you mean by enterprise data warehousing?
What are the advantages of using informatica as an etl tool over teradata?
Explain pushdown optimization $pushdownconfig parameter - informatica
Which are the different editions of informatica powercenter that are available?
Where can we find the throughput option in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Different sorts of metadata that stores in the storage facility?
What are the types of lookup transformation?
design of staging area?
write a query to retrieve the latest records from the table sorted by version(scd)
