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 do you load unique records into one target table and duplicate records into a different target table?
How can we remove the duplicates from flat file source?
Explain the shared cache and re-cache?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain the aggregator transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what is size of u r database?
Differentiate between a repository server and a powerhouse?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
difference between informatica 8.1.1 and 8.6
What is a standalone command task?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the prerequisite tasks to achieve the session partition?
What is workflow? What are the components of the workflow manager?
What is workflow manager?