Explain What are the steps to build the data warehouse?
Submitted by: AdministratorAs far I know...
Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios
Gather requirements,
Identify Source tables,
Identify Destination tables,
Data modelling
Source to target matrix preparation,
ETL flow preparation and scheduling,
Reporting
Submitted by: Administrator
Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios
Gather requirements,
Identify Source tables,
Identify Destination tables,
Data modelling
Source to target matrix preparation,
ETL flow preparation and scheduling,
Reporting
Submitted by: Administrator
Read Online Data Warehousing Basics Job Interview Questions And Answers
Top Data Warehousing Basics Questions
| ☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
| ☺ | Explain degenerate dimension table? |
| ☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
| ☺ | What are the Data Marts? |
| ☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
