Can we insert ,update ,delete in target tables with one
update strategy tran.?
Answer Posted / sehaj
WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
In how many ways we can create ports?
What is the use of an aggregator cache file?
is it possible to index the data in cache of lkp transformation ?
Informatica settings are available in which file?
How can we delete duplicate rows from flat files?
Explain the scenario which compels informatica server to reject files?
Explain the types of lookup transformation?
Differentiate between a database and data warehouse?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Differences between version 7.x and 8.x.
update strategy transformation in informatica
Write the unconnected lookup syntax and how to return more than one column.
What is a joiner transformation and why it is an active one?
How we can use union transformation?
how many types of dimensions are available in informatica?