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
What is data transformation manager process?
permutations of mapplet
What is the function of look up transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain the etl program with few examples.
Tell me about MD5 functions in informatica
Different sorts of metadata that stores in the storage facility?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a repository manager?
How union transformation is used?
can anyone explain me about retail domain project in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
can we override a native sql query within informatica? Where do we do it?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How do you take back up of repository?