Interested to Buy Any Domain ? << Click Here >> for more details...
What is Target Update Override? What is the Use ?
- 8 Answers
- 19865 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 |
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Can we create two repositories on same database instance in oracle?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What is the difference between informatica 8.x and 9.x
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
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
What are the challenges of Dataware housing in the future?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Which are the different editions of informatica powercenter that are available?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What are events in workflow manager?
Teradata 
