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
What is event and what are the tasks related to it?
How to load the data from people soft hrm to people soft erm using informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What you know about transaction control transformation?
Which are the different editions of informatica powercenter that are available?
What are multi-group transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the need of an ETL tool?
Write the advantages of partitioning a session?
What are roles and groups and benefits of using them?
What are the tuning techniques you applied during your last project
What is olap (on-line analytical processing?
How to generate sequence numbers?
What is a joiner transformation and why it is an active one?
How many transformations can be used in mapplets.