How to identify this row for insert and this row for update
in dynamic lookup cache
Answer Posted / kish
Hi Based on NEW LOOKUP ROW..informatica server indicates
which one is insert and which one is update.
New lookup row=0...no change
1....Insert
2....update
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is repository manager?
What is the maplet?
How can informatica be used for an organization?
What is primary and backup node?
Write the unconnected lookup syntax and how to return more than one column.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How does a sorter cache works?
What is aggregate cache in aggregator transformation?
Describe data concatenation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What does role playing dimension mean?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the main issues while working with flat files as source and as targets ?