Explain What is the flow of loading data into fact & dimensional tables?
Submitted by: AdministratorHere is the sequence of loading a datawarehouse.
1. The source data is first loading into the staging area, where data cleansing takes place.
2. The data from staging area is then loaded into dimensions/lookups.
3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.
Submitted by: Administrator
1. The source data is first loading into the staging area, where data cleansing takes place.
2. The data from staging area is then loaded into dimensions/lookups.
3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.
Submitted by: Administrator
Read Online Warehouse DataStage Job Interview Questions And Answers
Top Warehouse DataStage Questions
| ☺ | How to fix the error "OCI has fetched truncated data" in DataStage? |
| ☺ | How to kill the job in data stage? |
| ☺ | Explain What does a Config File in parallel extender consist of? |
| ☺ | Explain How to handle the rejected rows in datastage? |
| ☺ | What is iconv and oconv functions? |
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. |
