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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the features of complex mapping?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how to load dimension table and fact table. plz tell me the steps.
How you can differentiate between connected lookup and unconnected lookup?
What do you understand by a term domain?
How to do unit testing in informatica?
What are the components of the workflow manager?
Explain pushdown optimization and types in informatica
Why update strategy and union transformations are active?
What is parallel processing in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is meant by lookup transformation?
What is union transformation in informatica?
What are data-driven sessions?
