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 |
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Why we use stored procedure transformation?
wf dont have integration severances how you can run?
Explain load alternative records / rows into multiple targets - informatica
What is A cache?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
What is the role of informatica in project ?Like i showed financial projects?
what is informatica metadata?
wht is cdc?how to use it in creation of mappings?