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
Explain pushdown optimization and types in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How many dimensions are there in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the difference between source qualifier transformations source filter to filter transformation?
What are ETL Tools?
difference between informatica 8.1.1 and 8.6
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the difference between stop and abort in informatica
How to Create a folder using pmrep command?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What do you understand by SOA of Informatica?
How are indexes created after completing the load process?
What is meant by pre and post session shell command?