Interested to Buy Any Domain ? << Click Here >> for more details...
What is target update override
- 2 Answers
- 7578 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / usha
target update override which is used to update the data
with out using UPDATE transformation....
if there is no PK in the target we can update by using
target update override
| Is This Answer Correct ? | 1 Yes | 0 No |
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Explain pushdown optimization and types in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
Types of error logs in Informatica?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Explain why we use partitioning the session in informatica?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What is confirmed dimension and fact?
what is lookup chache?
What are ETL Tools?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Teradata 
