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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / srinivasarao

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

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

What is the scenario which compels informatica server to reject files?

0 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

Explain the scenario which compels informatica server to reject files?

0 Answers  

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

how to work with mapplet designer in informatica?

7 Answers  

Could any one to tell Fact table Partitioning?

2 Answers  

what is correlated query?

2 Answers   IBM,

what is the look up transformation?

2 Answers   Informatica,

What are the different ways to implement parallel processing in informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories