what is target update override and when we use it?
Answers were Sorted based on User's Feedback
Answer / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.
Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by active and passive transformation?
What are the options in the target session of update strategy transsformatioin?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
What do you mean by channel change?
What is the Rank index port in Rank transformation?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
Is it possible to update the target table with PK?
What is a filter transformation?
How can i set break points in debugging mode ? can explain steps please?
How can you increase the performance in joiner transformation?