what is lookup ?

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


Please Help Members By Posting Answers For Below Questions

How to load a Dimension ? and how to load a fact table?

931


what is index?how it can work in informatica

1553


what is the hint? how to use it to reduce the query processing in program?

6186


How many numbers of sessions can one group in batches?

596


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.

752






What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6360


What is the Rank index port in Rank transformation?

646


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

1674


difference between informatica 8.1.1 and 8.6

3222


Whats the difference between informatica powercenter server, repositoryserver and repository?

643


What are the static cache and dynamic cache in informatica?

680


waht type of interface is used for testing the data in informatica

1809


Is it possible to use a client with different version than that of its Informatica server?

612


Explain the different kinds of facts.

541


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

1613