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
How to load a Dimension ? and how to load a fact table?
what is index?how it can work in informatica
what is the hint? how to use it to reduce the query processing in program?
How many numbers of sessions can one group in batches?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the Rank index port in Rank transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
difference between informatica 8.1.1 and 8.6
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the static cache and dynamic cache in informatica?
waht type of interface is used for testing the data in informatica
Is it possible to use a client with different version than that of its Informatica server?
Explain the different kinds of facts.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica