Data Warehouse General Interview Questions
Questions Answers Views Company eMail

what are the major three types of modeling used?

InfoAxon Technologies,

606

what is an use case?

InfoAxon Technologies,

608

Why should we use data ware housing and how can you extract data for analysis with example?

TCS,

548

What is the purpose of Dataware Control?

CGI,

590

What is conformed fact?

618

What are the key columns in Fact and dimension tables?

540

What is Star Schema?

Informatica,

635

What are the types of SCD?

622

What is VLDB?

602

What are Aggregate tables?

679

What are loops in Datawarehousing?

550

How can we load the time dimension?

692

What is a core dimension?

604

What are Non-additive facts?

652

What is real-time datawarehousing?

596


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is data stream and data adaopter?

603


Explain what are non-additive facts in detail?

576


Explain how many ways you create ports?

601


What is the difference between er modeling and dimensional modeling?

586


What is the difference between aggregate table and materialized view?

586






Explain me what are conformed dimensions?

535


What are the data types present in bo? What happens if we implement view in the designer n report?

538


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

519


What is real-time datawarehousing?

596


How many types of facts and what are they?

542


What is a hash cluster?

509


Explain vldb?

615


How to reduce warnings?

517


For faster process, what we will do with the universe?

559


What are the differences between datamart vs. Reporting cube?

472