What are the options in the target session of update
strategy transsformatioin?
Answer Posted / santhoshi
INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
Implementation methodology
What is main use of mapplet?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the sequence generator transformation in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to update or delete the rows in a target, which do not have key fields?
What is data transformation manager process?
how we can load rejected record's at run time?(not through bad files)
What is olap (on-line analytical processing?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the tasks that source qualifier perform?
Explain sql transformation in script mode examples in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?