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
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is difference between drill & scope of analysis?
The same tier?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain the main differences between star and snowflake schema?
Define Data Warehousing?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is metadata in context of a datawarehouse?
Where the applications and where ware house management system is used?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is Cognos script editor?
How many types of facts and what are they?
What are the types of partitioning?
What are the various tools? Explain name a few?