Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is critical column?

684

What is "method/1"?

598

Explain the difference between data ware house & data mart?

561

After the complete generation of a report who will test the report and who will analyze it?

559

What is the difference between snowflake and star schema?

589

Explain the importance of data warehouse?

578

How can we run the graph? What is the procedure for that?

517

What is a source qualifier?

548

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

569

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

515

What is difference between e-r modeling and dimensional modeling?

524

What is a hash cluster?

532

What is data analysis? Where it will be used?

569

What are the methodologies of data warehousing?

580

What is the difference between dependent data warehouse and independent data warehouse?

612


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

560


Explain the difference between view and materialized view?

521


Suggest a good author for hyperion in data warehousing?

568


How can you import tables from a database?

568


Explain what are necessary tasks to install reportnet software?

501






After we create a scd table, can we use that particular dimension as a dimension table for star schema?

558


Why denormalization is promoted in universe designing?

567


Explain what is a three tier data warehouse?

552


What is freehand sql?

617


How to create different types of templates?

524


Explain what is the difference between olap and datawarehosue?

612


What are the types of dimensional modeling?

628


Explain the different types of data warehousing?

587


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

526


Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

1690