without update strategy how to insert &update?
Answer Posted / nivas
First you create the mapping according to your requirement
after that you create session.
Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
permutations of mapplet
What is a mapplet/worklet in informatica?
How do you load only null records into target? Explain through mapping flow.
What is flashback table ? Advance thanks
How do you load unique records into one target table and duplicate records into a different target table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are some examples of informatica etl programs?
what is the size of u r source(like file or table)?
Differentiate between source qualifier and filter transformation?
Clarify the utilization of aggregator cache record?
How do you change a non-reusable transformation to reusable transformation?
How can we store previous session logs?
How can we improve session performance in aggregator transformation?
r u done any partitions in ur project?
what is unit testing?tell me proceedure