Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / sreedhar lokaray
Yes you can insert or update a table without using update
strategy. In the Mapping tab of the Session property go to
Target properties and check the attribute value Insert to
insert or check Update as Update to update.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
What is a rank transform?
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 .
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is InformaticaPowerCenter?
What does refresh system mean, and what are its distinctive choice?
Please let me know how to make Data masking in informatica..
What is the function of look up transformation?
Mention a few design and development best practices for informatica?
How can repository reports be accessed without sql or other transformations?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the sql query overwrite in source qualifier in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain load alternative records / rows into multiple targets - informatica