Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is Target Update Override? What is the Use ?

Answers were Sorted based on User's Feedback



What is Target Update Override? What is the Use ?..

Answer / srinu

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

What is Target Update Override? What is the Use ?..

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

What is Target Update Override? What is the Use ?..

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

What is Target Update Override? What is the Use ?..

Answer / cv4u.dl

Thaks Srinu & Himanshu for posting answers.

Is This Answer Correct ?    1 Yes 1 No

What is Target Update Override? What is the Use ?..

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

What is Target Update Override? What is the Use ?..

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

What is Target Update Override? What is the Use ?..

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

What is Target Update Override? What is the Use ?..

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

Post New Answer

More Informatica Interview Questions

When you move from devel to prod how will you retain a variable

1 Answers  


What are the different options available for update strategy?

0 Answers  


8.what is mapplet ?give example?

2 Answers  


How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


How can you generate reports in informatica?

0 Answers  


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


what is mapping optimization? wat are the techniques for tat

2 Answers  


What is meant by LDAP users?

0 Answers  


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


how to sort date field in infomatica?

2 Answers  


explain about session partitions ?

1 Answers  


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


Categories