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
What is complex mapping?
Enlist some properties of sessions.
What is the use of an aggregator cache file?
How does a rank transform differ from aggregator transform functions max and min?
Explain informatica architecture - version 8 / 9
scenario where i can use only concurrent execution of workflow.
What is transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is enterprise data warehousing?
What could be the possible resons of locks by user?
What is standalone command task?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is Data Caches size?
Explain lookup transformation source types in informatica