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 |
Explain the use of aggregator cache file?
how we do performence tuning in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the difference between lookup override and souce qualifier override ?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Difference Between ETL & ELT?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What is incremental aggregation?
State the limitations where we cannot use joiner in the mapping pipeline?
Can we have a Mapping without a Source Qualifier?
which one is better either active or passive transformation in informatica
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?