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
How can you define user defied event?
What are multi-group transformations?
have u done any performance tuning? how u ll do?
How can we use mapping variables in informatica?
Mention a few design and development best practices for informatica?
Tell me about Propagate functions in informatica
Define pmcmd command?
How is union transformation utilized?
How can we use batches?
Do you find any difficulty while working with flat files as source and target?
Is there any target staging area in informatica not staging area
What is the commit type if you have a transaction control transformation in the mapping?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can we improve session performance in aggregator transformation?
without table how to come first record only in oracle?