when should one create lookup transformation ?

Question Posted / jakki

2 Answers
5346 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when should one create lookup transformation ?..

generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.

Is This Answer Correct ?

3 Yes

0 No

when should one create lookup transformation ?..

Answer / kaki

Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More ETL Interview Questions

without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers

What is tracing level?

0 Answers

what is the difference between date cache and lindex cache?

1 Answers

Is hadoop a etl tool?

0 Answers

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers

What is partitioning? Explain different types of partitioning?

0 Answers

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

0 Answers

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

0 Answers HCL,

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers Accenture,

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers QualTech,

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers IBM, Saama Tech, Wipro,

working of line item dimension......pls,tell overall flow

1 Answers

For more ETL Interview Questions Click Here