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 6801

What is confirmed dimension?

JPMorgan Chase,

7 16464

What is the capacity of power cube?

2 6701

Difference between PowerPlay transformer and power play reports?

CTS,

2517

What is IQD file?

1 5615

What is Cognos script editor?

2556

What is difference macros and prompts?

2307

What is power play plug in?

3 4780

Which kind of index is preferred in DWH?

1 8654

What is hash partition?

TCS,

3 5338

What is DTM session?

1 9275

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

TCS,

7 11071

What is mapplet?

1 6540

What is query panel?

1 3918

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

1 5168

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the types of partitioning?

1049

Explain a mapping, session, worklet, workflow, mapplet?

1106

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1972

What is dimension modeling?

1088

Why we use repository connectivity?

981

What is a general purpose scheduling tool?

1113

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1131

How we are using this function?

1118

What are the various tools? Explain name a few?

959

What are algorithms provided by Microsoft in SQL Server?

2054

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

Why null values are mapped as 0 in fact tables?

1004

How to stop a batch?

984

List any five applications of data warehouse.

939

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