Data Warehouse General Interview Questions
Questions Answers Views Company eMail

what type of raid setup would you put your tx logs?

505

What is a general purpose scheduling tool?

529

What is the metadata extension?

520

What a static and local variable?

564

Explain when do we analyze the tables? How do we do it?

594

Explain what are the different methods of loading dimension tables?

478

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

515

Explain what is full load & incremental or refresh load?

510

Explain what is the metadata extension?

555

What are the main steps to build the data warehouse?

632

Explain what is the difference between datawarehouse and bi?

498

What is scd1 , scd2 , scd3?

639

Explain the difference between oltp and olap?

652

What is a data warehousing?

586

What is a fact table?

1 909


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what is partitioning? What are the types of partitioning?

485


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

507


Explain multivalued dependency?

548


What are the different types of segments?

524


Explain a relation schema and a relation?

562






What is the difference between star and snowflake schemas?

574


Explain the versions of reportnet?

528


What are various warehousing tools?

552


If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

498


What are the different methods of loading dimension tables?

543


Explain what is the limit to the number of sources and targets you can have in a mapping?

524


What are the various methods of getting incremental records or delta records from the source systems?

510


What is the very basic difference between data warehouse and operational databases?

436


What is is a star schema?

538


What is your spectra photometer working principles?

539