Can any one explain about core dimension, balanced dimension, and dirty dimension?
No Answer is Posted For this Question
Be the First to Post Answer
In microstrategy, how can we direct the sql generated to use a specifc table?
Suppose we want to display zero when null values coming to report how can we do that?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is index awareness in universe?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain degenerate dimension table?
Can decision tree be implemented using SQL?
Explain Process flow in data warehouse??
What is Data purging?
What is Active Datawarehousing?