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 are the Methods For Creating Reusable Transformations?
What do you understand by term role-playing dimension?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is mapplet in informatica?
What is lookup transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In which transformation you cannot drag ports into it?
What are the guidelines to be followed while using union transformation?
Mention a few design and development best practices for informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are multi-group transformations?
What is meant by a domain?
What is the Rank index port in Rank transformation?
What is the different lookup cache(s)?