Can we insert and update a target table without using update
strategy transformation?How?
- 4 Answers
- 21725 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 is fact table? Explain the different kinds of facts.
In a table, 4 person having same salary. How to get Third person record only?
any body can say about all versions of informatica ?how many versions ?
tell me 7.x and 8.x diferrencess(but not transformations)
h0w many versions have been developed of onformatica so far?
What are the popular informatica products?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
Teradata 
