What is a look up function? What is default transformation
for the look up function?
Answer Posted / guest
look up compares the source to target.it update and insert
the new rows to the target.
the default transformation for look up is source qualifier
| Is This Answer Correct ? | 13 Yes | 9 No |
Post New Answer View All Answers
What is a difference between complete, stop and abort?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the prerequisite tasks to achieve the session partition?
What do you mean by blocking transformation?
How are indexes created after completing the load process?
What are the different ways to implement parallel processing in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How do you load only null records into target? Explain through mapping flow.
Explain in detail scd type 2 through mapping.
What are the advantages of using informatica as an etl tool over teradata?
What is Cognos script editor?
How can we update a record in the target table without using update strategy?
What are data-driven sessions?
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.