What is Target Update Override? What is the Use ?
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 |
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
what is correlated query?
How many repositories can we create in Informatica??
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
What is a test load?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
Mention few power centre client applications with their basic purpose?
What are the types of error logs available in Informatica?
Explain the types of transformations?
Without using Lookup & Sequence Generator, How to generate Sequence?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation