Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeep.t nizamabad
OLTP SYSTEMES CONTAINS
1.FLAT FILES
2.DBASE
3.ORACLE
4.SAP
WE WILL EXTRACT THE DATA FROM OLTP TO STAGING LAYER
AND CONVERT THE DATA FROM INCONSISTENT TO CONSISTENT FORM
BEFORE LOADING TO DWH.
DWH IS NOTHING BUT OLAP SYSTEMS
IT CONTAINS DEPTS. LIKE FINANCE,SALES,PURCHASE,H.R
DATA MARTS ARE SUBSETS OF AWHWHICH ARE USED TO SATISFY THE
REPORTING REQUIREMENTS OF A DEPTS
Eg: SALES , FINANCE,PURCHASE,HR
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
ware house management system is used?
Explain what is the data type of the surrogate key?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What we will do with the universe for faster process?
Explain can report net connect multiple datasource at a time in report creation time?
Explain which columns go to the fact table and which columns go the dimension table?
How can we load the time dimension?
Explain what is analytical or analytic mean?
Explain a relation schema and a relation?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are the different types of scd's used in data warehousing?
How to add a number to a macro variable?
Compare aggregates and data marts
Explain conformed fact?
