Explain the definition of normalized and denormalized view and what are the differences between them?
924What are situations where snow flake schema is better than star schema to use and when the opposite is true?
996Post New Data Warehouse General Questions
What is surrogate key? Where we use it? Explain with examples.
Explain what are necessary tasks to install reportnet software?
I need to set predefined condition. How I do this?
Explain the difference between oltp and olap?
Name a few sectors which use data warehousing?
What are the different problems that ?Data mining? can solve?
What is crass reference table?
What we will do with the universe for faster process?
What is surrogate key? Explain with examples.
How to pivot data using informatica when you have variable amount of pivot rows?
How are the dimension tables designed?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is conformed fact?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is drilling across?