Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is lookup ?

Answers were Sorted based on User's Feedback



what is lookup ?..

Answer / 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

what is lookup ?..

Answer / sai suresh

2 . Look up data in relational able, view, or synonym,
Input a look up definition from any relational data base to
which both the informatica client and server can connect.
You can use multiple lookup transformations in mapping.

Is This Answer Correct ?    3 Yes 0 No

what is lookup ?..

Answer / nagarjuna redd

Use to Lookup a data of table,view and synonym from a
relational or flat files. U can use multiple lookup
transformations in mapping.
- Used to get a related value
- used to perform a calculation
- mainly used in slowly changing dimension

Is This Answer Correct ?    4 Yes 1 No

what is lookup ?..

Answer / priya

look up transformation is used to look the data either from
source or target whenever the req feild is not in the
mapping.
we can use two or more tables as look up by using the join
condition

Is This Answer Correct ?    3 Yes 0 No

what is lookup ?..

Answer / kumarapillaietl@gmail.com

in before informatica powercenter 9 version lookup it is works passive tranformation ,after that 9X lookup works both passive and active ,
informatica provide aditional features, at the time of lookup creation (multi match) check bok option is there , when you check multi match its works active.
genraly we can get source table,target tables,flatfiles al lthous thinks and compare hetroginious sources using lookup.
lookup participate each SCD mappig flow.

Is This Answer Correct ?    1 Yes 0 No

what is lookup ?..

Answer / sai suresh

I think look up is a transformation it is mostly used for
slowly changed dimenctions(SCD). with the help of look up
T/R we can join to dimention tables. These tables may
Hetrogonies tables


Posni_sai@yahoo.com
sai suresh

Is This Answer Correct ?    0 Yes 1 No

what is lookup ?..

Answer / giri

Lookup connected,unconnected and Passive transformation. Looking for related values and inserting flake values.

Inserting Flag value

0 - No Change
1 - Insert
2 - Update

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is the benefit of partitioning a session?

0 Answers  


when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,


What is meant by target load plan?

0 Answers  


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,






What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  


What is the status code?

1 Answers  


Define the various join types of joiner transformation?

0 Answers  


What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,


What is tracing level and what are the types of tracing level?

2 Answers   TCS,


Categories