Can we insert and update a target table without using update
strategy transformation?How?
Answers were Sorted based on User's Feedback
Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
T/r.
Regards,
rayudu.
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
Answer / kajal mishra
Yes we can update records in informatica without update strategy .
During session configuration, you can select a single database operation for all rows using the Treat Source Rows as setting from the ‘Properties’ tab of the session.
Insert :- Treat all rows as inserts.
Delete :- Treat all rows as deletes.
Update :- Treat all rows as updates.
Data Driven :- Integration Service follows instructions coded into Update Strategy flag rows for insert, delete, update, or reject..
In case we set treat rows as update , we can set more option for individual target tables.
I found a good asrticle on http://tutorialcorner.com/2016/03/update-without-update-strategy-in-informatica/
Is This Answer Correct ? | 5 Yes | 0 No |
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Global and Local shortcuts. Advantages.
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
Quickly characterize reusable change?
What is router transformation
Without using Lookup & Sequence Generator, How to generate Sequence?
What are the tasks that source qualifier perform?
Can we get 1st record through Informatica(without sequence number).
To provide support for Mainframes source data,which files r used as a COBOL files
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time