How Are The Dimension Tables Designed?

1.	How Are The Dimension Tables Designed?
Answer» Find where data for this DIMENSION are located. FIGURE out how to extract this data. DETERMINE how to maintain CHANGES to this dimension. Change FACT table and DW population routines. Find where data for this dimension are located. Figure out how to extract this data. Determine how to maintain changes to this dimension. Change fact table and DW population routines.

Answer»

Find where data for this DIMENSION are located.
FIGURE out how to extract this data.
DETERMINE how to maintain CHANGES to this dimension.
Change FACT table and DW population routines.

Find where data for this dimension are located.
Figure out how to extract this data.
Determine how to maintain changes to this dimension.
Change fact table and DW population routines.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?

How Are The Dimension Tables Designed?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment