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

What is factless fact schema?

2 6904

What is confirmed dimension?

JPMorgan Chase,

7 16711

What is the capacity of power cube?

2 6815

Difference between PowerPlay transformer and power play reports?

CTS,

2560

What is IQD file?

1 5708

What is Cognos script editor?

2616

What is difference macros and prompts?

2389

What is power play plug in?

3 4919

Which kind of index is preferred in DWH?

1 8725

What is hash partition?

TCS,

3 5455

What is DTM session?

1 9356

How can you define a transformation? What are different types of transformations in Informatica?

TCS,

7 11328

What is mapplet?

1 6618

What is query panel?

1 4013

What is a look up function? What is default transformation for the look up function?

1 5261

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the various transformation available?

1059

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

1079

What is mean by aggregate aware?

1155

What are the difference between snow flake and star schema?

1059

How can we load the time dimension?

1250

What is called dimensional modelling?

1183

what are relationships?

1108

Can a dimension table contain numeric values?

1113

Where the data cube technology is used?

1007

Explain what is ods (operation data source)?

1033

Explain what are the modules in power mart?

1094

What are data modeling and data mining? Where it will be used?

1028

What is the differences between star and snowflake schemas?

1115

How to performance tune reports?

1258

What is index awareness in universe?

1088

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