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


Please Help Members By Posting Answers For Below Questions

what are the Methods For Creating Reusable Transformations?

649


What do you understand by term role-playing dimension?

574


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

3448


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?

552


What is mapplet in informatica?

594






What is lookup transformation?

596


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

628


In which transformation you cannot drag ports into it?

776


What are the guidelines to be followed while using union transformation?

639


Mention a few design and development best practices for informatica?

561


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

695


What are multi-group transformations?

564


What is meant by a domain?

630


What is the Rank index port in Rank transformation?

669


What is the different lookup cache(s)?

610