Why should we use data ware housing and how can you extract data for analysis with example?
TCS,
997Post New Data Warehouse General Questions
What are data modeling and data mining? Where it will be used?
Database in use is oracle?
What are Aggregate tables?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
How much data hold in one universe.
How can we determine what records to extract?
Explain what is a three tier data warehouse?
Give some difference between oltp and olap.
What are the differences between star and snowflake schema?
Explain what are the steps to build the data warehouse?
What are the stages that are required in data warehousing?
What is a core dimension?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is the difference between constraind base load ordering and target load plan?
I know of using applysimple, but there are other ways too?