Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / rayudu
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 |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the different ways to implement parallel processing in informatica?
What is the command used to run a batch?
Differentiate between router and filter transformation?
define galaxy repository in informatica
Reusable transformation and shortcut differences
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what are the Methods For Creating Reusable Transformations?
What's the layout of parameter file (what does a parameter file contain?)?
Which transformation should we use to normalise the COBOL and relational sources?
How to join three sources using joiner?
What do you mean by worklet?
What is workflow monitor?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?