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?

1310

What are the kinds of layouts does ab initio supports?

1062

What are the primary keys and foreign keys?

1222

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

1166

Have you used the rollup component? Describe how?

1174

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?

1314

Explain about ab initio’s dependency analysis?

1246

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

1180

Describe in detail about lookup?

1130

Why do you think data processing is important?

1171

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

1309

What are the facts that can compromise data integrity?

1202

What a local lookup is?

1115

How many components in your most complicated graph?

1379

Define ramp limit in ab initio?

1329

Un-Answered Questions { Data Warehouse }

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2134

Name the different lookup cache(s)?

1298

what is enterprise guide? What is the use of it? : Sas programming

1077

What is the use of function Proc summary?

1352

Can you explain link buffering?

1227

How can we handle two sessions in informatica?

1098

Can we create a node as a gateway node and the same node can be assigned to a grid?

1125

Explain the differences between normalizer and normalizer transformation?

1109

Where is tm1 web logging information found?

Explain difference between onrow and onread method?

941

What are the limitations for memory allocation for SAS variables

1555

how do u really know that paging to disk is happening while u are using a lookup transform?

2043

Explain some of modeling tools available in the market?

1029

What is the maximum and minimum length of macro variable

1355

what is slowly changing dimension? : Sas-di

1188

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