Differentiate between a database and data warehouse?
- 1 Answers
- 1230 Views
- I also Faced
- E-Mail Answers
Answer / Laxmi Balmiki
Although databases and data warehouses both store data, they have several key differences:
- Database is used for transactional processing and operational reporting, while a data warehouse focuses on analytical processing and business intelligence.
- A database stores current and up-to-date data, whereas a data warehouse stores historical data for analysis purposes.
- Databases are typically normalized to minimize redundancy, while data warehouses are denormalized for improved query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Explain dynamic target flat file name generation in informatica
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What is a sequence generator transformation?
What is DR strategy for Informatica project?
Can we use the mapping parameters or variables created in one mapping into another mapping?
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.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is meant by target load plan?
where does the default group roew in a router is stored what is the default size of memory in router
what is the difference between stop and abort
Teradata 
