What is up date strategy and what are the options for update
strategy?

Answer Posted / jyothi

Update strategy is used for flagging the records by using
the options insert/update/delete/reject.
Update strategy is used in two levels.
session level:at session level we have to use the options
update as insert,update as update,update else insert.
mapping level:at mapping level we have to use the options
dd-insert,dd-update,dd-reject,dd-delete.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

COM components can be used in Informatica

1881


What is an unconnected transformation?

669


Can u generate reports in Informatica?

661


lookup transformation with screenshots

3559


Explain lookup transformation source types in informatica

702






What do you mean by worklet?

637


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1925


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


Explain the types of lookup transformation?

577


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

3455


How do you load unique records into one target table and duplicate records into a different target table?

714


In informatics server which files are created during the session rums?

639


Describe an informatica powercenter?

609


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793