Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Explain what are the various transformation available?

1074

How to reduce warnings?

991

What is the difference between a primary and secondary actor in use case modeling?

1129

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

1011

Explain meta data?

1108

Explain why are oltp database designs not generally a good idea for a data warehouse?

1079

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

996

Explain is olap databases are called decision support system true/false?

1064

How can we determine what records to extract?

1137

What is a staging area? Do we need it? What is the purpose of a staging area?

1041

Explain which are the olap tools available that are supported by oracle?

1048

Explain some of modeling tools available in the market?

1021

Explain what are non-additive facts?

1072

Explain what is the difference between power center & power mart?

1047

Explain if a flat file cotains 1000 records how can I get first and last records only?

966

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are various warehousing tools?

1071

What are session timeout and application timeout?

1059

What are the other names given to data warehousing?

1149

Explain reference cursor?

2225

What is data type of the surrogate key?

1054

Explain what is the difference between olap and datawarehosue?

1142

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

1008

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2097

What is the definition of cube in datawarehousing?

1038

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2185

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?

978

What needs to be done while starting the database?

1157

What are the differences between star and snowflake schema?

1177

What is a source qualifier?

1156

What is ods (operation data source)?

1060

For More Un-Answered { Data Warehouse General } Questions Click Here