Explain Which columns go to the fact table and which columns go the dimension table?
Submitted by: AdministratorThe Primary Key columns of the Tables(Entities) go to the Dimension Tables as Foreign Keys.
The Primary Key columns of the Dimension Tables go to the Fact Tables as Foreign Keys.
Submitted by: Administrator
The Primary Key columns of the Dimension Tables go to the Fact Tables as Foreign Keys.
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
☺ | What is SCD1 , SCD2 , SCD3? |
☺ | What is ODS? |
☺ | Explain piconet? |
☺ | Explain the Difference between OLTP and OLAP? |
☺ | Explain What are the Different methods of loading Dimension tables? |
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. |