without update strategy how to insert &update?
Answer / 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 |
What is update strategy transform?
What are the tasks that source qualifier performs?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is an expression transformation?
What are the different tools in workflow manager?
How to delete first 3 rows & last 3 rows in target table in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is the Difference between DSS & OLTP?
what is incremantal aggregation?
Define sessions in informatica etl?