What is Target Update Override? What is the Use ?
- 8 Answers
- 18060 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
When we don't have primary keys defined on database level.
And still we need update on this target from Informatica.
We neeed to define keys at informatica level and use update
override in target property. This way we can update the
table.
<source>-geekinterview.com
Any Queries or Corrections
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / kalyan
I guess Ans # 2 is not correct.. We can't write query on
flat files.. Please correct me I am wrong..
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / koti.
to update a relational file we should maintaian a primary
key on target. if we dont have such type of keys then we
should go for target update overide
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jayram
i think above answer is correct. if we dont have such type
of keys then we
should go for target update overide
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikneswaran
Target Update Override is used update the target table..
should give the update statement to the override section
depend on the condition the target table will be updated
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / divakar
The answer #1 is correct but I also think that this can be
used for updating when target is flat file too
| Is This Answer Correct ? | 1 Yes | 10 No |
Answer / himanshu
The answer #1 is correct but I also think that this can be
used for updating when target is flat file too
| Is This Answer Correct ? | 0 Yes | 17 No |
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
What is informatica etl tool?
Target increases every day even though no new record was inserted
How to extract the informatica rejected data?
What are the settings that you use to configure the joiner transformation?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
How do you load only null records into target? Explain through mapping flow.
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
what are presession,postsession success and postsession failure commands ?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Teradata 
