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
- 23403 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 |
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
What is substr in informatica?
What is informatica powercenter repository?
how to import multiple flat files in to single target where there is no common column in the flat files
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
how to use incremental load?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
HOW TO DELETE A RECORD FROM FLAT FILE
State the limitations where we cannot use joiner in the mapping pipeline?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Teradata 
