Why use the lookup transformation ?

Answer Posted / rekha

1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is index?how it can work in informatica

1578


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1027


How are indexes created after completing the load process?

985


How many input parameters can exist in an unconnected lookup?

986


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1204






What is a difference between complete, stop and abort?

637


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

671


Where can we find the throughput option in informatica?

600


permutations of mapplet

2038


What are the different components of powercenter?

578


How to handle decimal places while importing a flatfile into informatica?

714


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

630


What is the different lookup cache(s)?

610


Where do we use mapping variables in informatica?

612


Explain the shared cache and re-cache?

608