⟩ Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
Since in OLTP,tables are normalised and hence query response will be slow for end user and OLTP doesnot contain years of data and hence cannot be analysed.
Question and Answer:
Home General Datawarehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is the difference between filter and lookup transformation?
Explain How to import oracle sequence into Informatica?
Explain How to get the first 100 rows from the flat file into the target?
How to load time dimension?
Explain What are the measure objects?
Explain What are the basic needs to join two sources in a source qualifier?
What is the use of incremental aggregation? Explain me in brief with an example?
What are the joiner caches?
Explain What is power center repository?
Explain What is metadata reporter?
