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

What is status code?

2 Answers  


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


What is the status code?

1 Answers  


Define Incremental Aggregation?

2 Answers  


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


what is degenerated dimension table with scenario

2 Answers   HCL,


delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


Explain the etl program with few examples.

0 Answers  


What is the status code in stored procedure transformation?

0 Answers   Informatica,


where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,


Categories