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
Can we start and stop single session in concurent bstch?
How to know the time taken for particular report execution?
What is a functional dependency f said to be minimal?
what are the different views that are considered when building an object-oriented software system?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what are non-additive facts?
Define Data Warehousing?
what are relationships?
Explain what is the difference between powerplay transformer and power play reports?
What is the difference between Datawarehouse and OLAP?
What is called dimensional modelling?
Explain conformed fact?
Explain what are the possible data marts in retail sales?
Explain the main difference between inmon and kimball philosophies of data warehousing?
