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

How we can create indexes after completing the load process?

0 Answers  

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

What are the types of lookup?

3 Answers   Wipro,

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

What is the functionality of update strategy?

2 Answers  




HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

how did u understand business requirement?

2 Answers   TCS,

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

What are the different types of olap? Give an example?

0 Answers  

what is degenerated dimension

6 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories