Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert and update a target table without using update
strategy transformation?How?
- 4 Answers
- 23556 Views
- Syntel, I also Faced
- E-Mail Answers
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 |
What are Business Components in Informatica?
how to get flatfile containg 10 records half records one target another half another target
How can i set break points in debugging mode ? can explain steps please?
Can you use flat files in Mapplets.
what are challenges that you faced in testing? give solution to it?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
Major difference between SQL override and Lookup Sql override
explain different levels in pushdown optimization with example?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
expain about the tune parameters?
Discuss the advantages & Disadvantages of star & snowflake schema?
What are the types of lookup transformation?
Teradata 
