Why we use lookup transformations?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pmcmd command?

870


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1967


Explain constraint based loading in informatica

832


What are the different versions of informatica?

942


What is the fact table?

776


Explain sessions. Explain how batches are used to combine executions?

782


Did u used latest transformations of 8.6.0? for what?

1645


What is joiner transformation in informatica?

816


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1778


Explain scd type 3 through mapping.

763


According to his methodology what all you need before you build a datawarehouse

1416


How do you set a varible in incremental aggregation

1648


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2317


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1545


Explain target update override in informatica

838