What is Target Update Override? What is the Use ?
- 8 Answers
- 17433 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 a unit Testing?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What is native users?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What happens if we dont select data driven option?
What is target update override
server hot-ws270 is connect to Repository B. What does it mean?
what is diffrence b/w joner and union transfermation
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
what is worklet and what use of worklet and in which situation we can use it?
In session log thier should not be a single error how will u do
What is the fact table?
Teradata 
