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
differences between service based and product based?
What are mapplets? How is it different from a Reusable Transformation?
What are the advantages of informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Why union transformation is an active transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is olap (on-line analytical processing?
How many numbers of sessions can one group in batches?
What is meant by target load plan?
How identifying bottlenecks in various components of informatica and resolving them?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the guidelines to be followed while using union transformation?
What do you mean by enterprise data warehousing?