why do we go for update strategy tr in SCD rather using the
session properties?
Answer Posted / shweta
Actually its important to use a update strategy
transofmration in the SCD's as SCDs maintain some historical
data specially type 2 dimensions. In this case we may need
to flag rows from the same target for different database
operations. Hence we have no choice but to use update
strategy as at session level this will not be possible.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
According to his methodology what all you need before you build a datawarehouse
What are the new features of Power Center 5.0?
What are the tasks that source qualifier perform?
On which transformations you created partitions in your project?
How to extract sap data using informatica?
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 many dimensions are there in informatica?
What are the measure objects?
What can we do to improve the performance of informatica aggregator transformation?
what is $$$$?
what is SDLC way of code development?
What are the informatica performance improvement tips
What are the modules in Power Center
Explain dynamic target flat file name generation in informatica