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

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

HSBC,

7 22442

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 22285

how to we create datamart?

HSBC,

2 8400

wht is cdc?how to use it in creation of mappings?

HSBC,

6 22912

wht target override?wht advantages it has compare to target update?

Polaris,

2 13805

can anybody tell me about issues faced while creating reports

Accenture, Tech Mahindra,

1 2982

Can anybody tell me about issues faced while creating universe. thanks in advance

Accenture,

1 12246

can anybody tell me about issues faced while creating reports

Accenture,

3 9303

can anybody tell me about complicated object you have created

3222

how many user were there

1 4414

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

Patni,

3 16814

how many reports have u created ? explain a few.

InfoStep, Ness Technologies, TCS,

1 5171

can anybody tell me how many classes where there and objects in each class

3 6205

how many reports have u created ? explain a few.

Bank Of America, TCS,

2098

Name statements that function at both compile and execution time.

L&T,

3 9408

Un-Answered Questions { Data Warehouse }

What are the different methods ot loading a dimension table? A fact table etc?

1036

what is different between sequential batch and concurrent batch and which is recommended and why?

4927

Have you used macros? For what purpose you have used? : sas-macro

1041

What is a node in teradata?

997

Why cognos decision stream is used?

1159

can anybody mail me the FAQS for hyperion essbase amd planning

5646

what are the categories that sas informats are used to the place the data? : Sas-administrator

1049

Have you have ever worked in unix environment and why it is useful in datastage?

1133

What is basic teradata query language?

1113

How many types of transformations supported by sorted input?

1222

Tell e how how dealt with..

2253

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2906

What do the SAS log messages "numeric values have been converted to character" mean?

1380

Explain what is a three tier data warehouse?

975

What are stage variables, derivations and constants?

1224

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