wht target override?wht advantages it has compare to target
update?
Answer Posted / rkumar.etl
when table is having huge amount of records and performance
is the key factor to implement the target overrride ..if we
use update override it will take more time than the target
override.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
Sequence generator, when you move from develoment to production how will you reset
Define sessions in informatica etl?
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??
Where are the source flat files kept before running the session?
How do you load unique records into one target table and duplicate records into a different target table?
What is pmcmd command?
What is the Rank index port in Rank transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is unit testing?tell me proceedure
What is the difference between informatica 7.0 and 8.0?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
differences between service based and product based?