Data Warehouse General Interview Questions
Questions Answers Views Company eMail

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

536

What is a general purpose scheduling tool?

566

What is the metadata extension?

546

What a static and local variable?

597

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

624

Explain what are the different methods of loading dimension tables?

515

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?

541

Explain what is full load & incremental or refresh load?

539

Explain what is the metadata extension?

590

What are the main steps to build the data warehouse?

668

Explain what is the difference between datawarehouse and bi?

534

What is scd1 , scd2 , scd3?

690

Explain the difference between oltp and olap?

693

What is a data warehousing?

619

What is a fact table?

1 949


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Is there any difference in testing database and data ware housing?

2280


How can we schedule the graph in unix?

573


What is the difference between star and snowflake schemas?

611


What is the difference between mapping parameter & mapping variable in data warehousing?

564


What is many-to-many dimensional model in datawarehousing ?

520






What is your spectra photometer working principles?

564


What is the difference between constraind base load ordering and target load plan?

654


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

490


What needs to be done when the database is shutdown?

561


Explain normalization?

569


Explain what are conformed dimensions?

576


Explain what are non-additive facts in detail?

596


How do you define data block size?

595


What are the differences between star and snowflake schema?

501


Ist the schema that a data warehouse system can implements.

504