Why we use lookup transformations?

Question Posted / guest

1 Answers
6327 Views
I also Faced
E-Mail Answers

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

What is a command that used to run a batch?

2 Answers

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers Wipro,

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers IBM,

What is a code page?

0 Answers

what are the challenge face in u r project?explain me

1 Answers iGate, TCS,

Explain the difference between mapping parameter and mapping variable?

0 Answers

how to use incremental load?

2 Answers TCS,

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table