Explain what are the advantages of query studio compared to report studio?
No Answer is Posted For this Question
Be the First to Post Answer
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Which columns go to the fact table and which columns go the dimension table?
1.WHAT IS DATA MART ?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What are the design methods of data warehousing?
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?
What is meta data and system catalog?
What are session timeout and application timeout? Where we have to do this process?
What is an OLTP (Online Transaction Processing) System?
What is crass reference table?
What are non-additive facts in detail?