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
What is confirmed fact in dataware housing?
What is a filter transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is a sequence generator transformation?
Explain scd type 3 through mapping.
What are the components of Informatica? And what is the purpose of each?
How big was your fact table
How can we use mapping variables in informatica? Where do we use them?
How can we create index after completion of load process?
How union transformation is used?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
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
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How can we use batches?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
