Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is normalization, first normal form, second normal form, third normal form?

537

Explain where do we use semi and non additive facts?

569

What is cost benefit analysis (cba)?

589

Explain what is the data type of the surrogate key?

583

Explain what is the difference between olap and datawarehosue?

608

What are modeling tools available in the market?

565

Explain what is the advantages data mining over traditional approaches?

587

What is your spectra photometer working principles?

559

What we will do with the universe for faster process?

575

What are the various file formats involved in reportnet?

541

Explain how many ways you create ports?

617

Explain how to get the first 100 rows from the flat file into the target?

524

Why should you put your data warehouse on a different system than your oltp system?

504

Explain what are components of reportnet?

557

Explain a relation schema and a relation?

593


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are snapshots? What are materialized views & where do we use them?

530


Difference between e-r modeling and dimentional modeling?

497


What according to you might be the future of data warehousing?

534


Explain what is full load & incremental or refresh load?

535


What is the 4 + 1 view model as it relates to system modeling?

603






Give some difference between oltp and olap.

597


What is Cognos script editor?

2076


What is the difference between star and snowflake schemas?

601


What are the stages of datawarehousing?

543


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5476


What is surrogate key? Where we use it? Explain with examples.

549


What is the function of etl when used in data warehousing?

541


Can you pass sql queries in filter transformation?

541


What is normalization, first normal form, second normal form, third normal form?

537


What are the types of partitioning?

580