Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7345 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharu_295
ODS is a Replica of transactional data so it is OLTP and DW is an HIstorical Data so its OLAP.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vchandra
ODS stores operational data where as DWH store ODS data as
well as the history of the source database
| Is This Answer Correct ? | 1 Yes | 1 No |
Can any one explain or sujjest some sites for scd mappings.Thank you
What are the basic needs to join two sources in a source qualifier?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why we use stored procedure transformation?
How do you load only null records into target?
What is an expression transformation in informatica?
How do you change parameter when you move it from development to production.
What is the difference between IN and Exists in Oracle?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
i have source in oracle 10g,oracle 8i how will u take the data from two sources
What is flashback table ? Advance thanks
Teradata 
