Interested to Buy Any Domain ? << Click Here >> for more details...
what is lookup ?
- 7 Answers
- 16391 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What's the layout of parameter file (what does a parameter file contain?)?
what is metadata?
What is a candidate key?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
I want load the data into target with out 1st and last record.
Which is the t/r that builts only single cache memory?
How might one distinguish in the case of mapping is right or not without associating session?
How to enter same record twice in the target table,explain?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
can every transfomation reusable?how?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Teradata 
