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

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.

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

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

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.

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

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

What does cheating measurement mean?

0 Answers  

How can we remove the duplicates from flat file source?

0 Answers  

Write the advantages of partitioning a session?

0 Answers  

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

How do we call shell scripts from informatica?

0 Answers  

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

How mapping parameter and variable works

1 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

What you know about transaction control transformation?

0 Answers  

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

what is distinct

4 Answers