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
What is core dimension?
What are the other names given to data warehousing?
Explain what is batch and describe about types of batches?
Explain what are the different types of join operations?
ware house management system is used?
How to provide security in frame work manager for a query subject?
Explain what are the various reporting tools in the market?
explain about dirty dimension?
Explain what is difference between query studio and report studio?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain ddl (data definition language)?
What are the steps involved in designing a fact table?
Can you pass sql queries in filter transformation?
What are the tools available for etl?
What are the advantages and disadvantages of reporting directly against the database?
