Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bidhar
ODS can be described as a snap shot of the OLTP system.It
acts as a source for EDW(Enterprise datawarehouse).ODS is
more normalised than the EDW.Also ODS doesnt store any
history.Normally the Dimension tables remain at the ODS
(SCD types can be applied in ODS)where as the Facts Flow
till the EDW.
More importantly Client report reqiurements determing what
or what not to have in ODS or EDW.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
Is there any way to read the ms excel datas directly into informatica?
what is the hint? how to use it to reduce the query processing in program?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain joiner transformation in informatica
What are the types of caches in lookup?
What is the command used to run a batch?
Can anyone tell me the new features in Informatica 9 Version?
Difference between Target-based loading and constraint-based loading?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How many ways are there to create ports?
hi real timers . iam waiting for ur reply regarding ETL TESTING
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to delete duplicate row using informatica?
What are the different versions of informatica?
