Why we use lookup transformations?



Why we use lookup transformations?..

Answer / guest

we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Is there any way to read the ms excel datas directly into informatica?

0 Answers  


How might you approve all mappings in the archive all the while?

0 Answers  


Briefly explain the aggregator transformation?

0 Answers  


How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  






whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


What is Code Page Compatibility?

1 Answers  


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


Which kind of index is preferred in DWH?

2 Answers  


in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


What is dynamic cache?

0 Answers  


Categories