Answer Posted / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
How to call shell scripts from informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to do unit testing in informatica?
What are the components of the workflow manager?
Explain lookup transformation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is meant by lookup transformation?
What do you mean by blocking transformation?
Explain informatica architecture - version 8 / 9
What is the reusable transformation?
What is update strategy transform?
How does a rank transform differ from aggregator transform functions max and min?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?