How will you update the row without using update statergy?
Answer Posted / shiv
you can set the property at session level TREAT SOURCE ROWS
AS 'DATA DRIVEN'. BECOUSE WE CAN SET UPDATE AT MAPPING
LEVEL AND SESSION LEVEL.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is a predefined event?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
explan ur project architecture?
What is primary and backup node?
I have a flat file, want to reverse the contents of the flat file
Where is metadata stored?
Define update strategy?
What are the uses of etl tools?
What do you mean by channel change?
How to update source definition?
What are junk dimensions?
what is index?how it can work in informatica
Which version configuration tool used in ur project?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C