Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

533

Explain where do we use semi and non additive facts?

562

What is cost benefit analysis (cba)?

583

Explain what is the data type of the surrogate key?

578

Explain what is the difference between olap and datawarehosue?

601

What are modeling tools available in the market?

558

Explain what is the advantages data mining over traditional approaches?

579

What is your spectra photometer working principles?

557

What we will do with the universe for faster process?

565

What are the various file formats involved in reportnet?

538

Explain how many ways you create ports?

612

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

522

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

498

Explain what are components of reportnet?

553

Explain a relation schema and a relation?

587


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between power center & power mart?

502


Explain the data types present in bo n wht happens if we implement view in the designer n report?

538


what are the others of "bad files" and "discard files" when using sql*loader?

1625


What are modeling tools available in the market?

558


What are the data marts?

524






Explain what are the steps to build the data warehouse?

481


What is data stream and data adaopter. Is it same are different? Explain?

492


What is informatica architecture?

600


Explain conformed fact?

523


what is an use case?

622


What is execution plan?

745


Tell me what is full load & incremental or refresh load?

508


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1888


What is Star Schema?

643


What is surrogate key? Where we use it?

569