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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are the key elements of a data processing system?

1257

What are the kinds of layouts does ab initio supports?

1005

What are the primary keys and foreign keys?

1150

What exactly do you understand with the term data processing and businesses can trust this approach?

1119

Have you used the rollup component? Describe how?

1130

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1274

Explain about ab initio’s dependency analysis?

1180

What is the purpose of having stored procedures in a data-based?

1113

Describe in detail about lookup?

1094

Why do you think data processing is important?

1142

What are the steps to create a repository in ab initio?

1267

What are the facts that can compromise data integrity?

1157

What a local lookup is?

1062

How many components in your most complicated graph?

1315

Define ramp limit in ab initio?

1296

Un-Answered Questions { Data Warehouse }

What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?

967

What is the functional & architectural differences between business objects and web intelligence reports?

2425

Explain entity, attribute and relationship in datastage?

1117

what are the best practices to process the large data sets in sas programming? : Sas-administrator

1038

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

921

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2803

Explain what are the various reporting tools in the market?

993

Explain the term 'foreign key' related to relational database management system?

1052

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1085

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1077

How to partition the Session?

1122

What does command task mean?

1161

What is Metrics designer?

1037

What is persistent lookup cache?

1039

What’s the use of redshift?

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