wht target override?wht advantages it has compare to target
update?
Answers were Sorted based on User's Feedback
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 |
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 |
How we can create indexes after completing the load process?
In a concurrent batch if a session fails, can you start again from that session
What are the types of lookup?
Sequence generator, when you move from develoment to production how will you reset
What is the functionality of update strategy?
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
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.
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
how did u understand business requirement?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the different types of olap? Give an example?
what is degenerated dimension