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
- 23154 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 |
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What are the ETL tools available in DWH?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
How the Informatica Server reads perameter file?
What are differences between Informatica 7.1 and 6.1
Is snow flake or star schema used? If star schema means why?
what is diff between grep and find
What is active and passive transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Describe expression transformation?
Teradata 
