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...


wht target override?wht advantages it has compare to target
update?

Answers were Sorted based on User's Feedback



wht target override?wht advantages it has compare to target update?..

Answer / siva

Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.

To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.

Is This Answer Correct ?    8 Yes 1 No

wht target override?wht advantages it has compare to target update?..

Answer / rkumar.etl

when table is having huge amount of records and performance
is the key factor to implement the target overrride ..if we
use update override it will take more time than the target
override.

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is datamart

4 Answers   IBM, Informatica,


What is IQD file?

1 Answers  


Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,


How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,


How many cubes create from a single model?

1 Answers  


without table how to come first record only in oracle?

0 Answers  


I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  


write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


What is a data modeling?

2 Answers  


Categories