Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7523 Views
- I also Faced
- E-Mail Answers
Answer Posted / jteo
OLTP (Online Transaction Processing) database design is
normalised, which means it is optimized for INSERT, UPDATE.
Data warehouse design is not normalised but follows
dimensional modelling rules. They involve building star
schemas made up of fact tables and dimension tables and are
optimized for querying (SELECT).
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
How to increase performance without changing anything in mapping.( In prod)
how would u estimate the size of Aggregator transform data and index cache?
what are the session parameters? How do u set them?
Is apache nifi an etl tool?
Can there be sub steps of etl steps?
what is the use of server manager?
dimension object created in oracle can be imported in designer?how?
how would u estimate the size of Lookup transform data and index cache?
Mention few test cases and explain them?
State the differences between shortcut and reusable transformation
What is the difference between round-robin partitioning and hash partitioning?
where is the cache (lookup, index) created and how can you see it.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
