what is target update override and when we use it?
Answer Posted / 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 |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How identifying bottlenecks in various components of informatica and resolving them?
How many numbers of sessions can one group in batches?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to call shell scripts from informatica?
State the differences between sql override and lookup override?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Differentiate between reusable transformation and mapplet.
What are connected or unconnected transformations?
Why update strategy and union transformations are active? Explain with examples.
What is sq transformation?
What are some examples of informatica etl programs?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is standalone command task?