wht target override?wht advantages it has compare to target
update?
Answer Posted / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
tell me about your project functionality
What is event and what are the tasks related to it?
lookup transformation with screenshots
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the static cache and dynamic cache in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
On which transformations you created partitions in your project?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to elaborate tracing level?
What is a transaction control transformation?
What is a sequence generator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Explain the types of lookup transformation?
What are the mapping parameters and mapping variables?