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 do you understand by the cognos?

991

What are various types of gateways in cognos?

1082

What do you mean by query studio?

959

What do you understand by user class in cognos?

965

What are the advantages of cognos?

994

Why cognos decision stream is used?

1179

Distinguish between cognos dynamic cube and transformer/tm1 cube and powerplay cube?

Differentiate between ceil and floor functions.

1173

Explain why double trailing @@ is used in input statement?

1082

What are pdv and it functions?

1168

Differentiate input and infile.

1119

Name and describe few sas character functions that are used for data cleaning in brief.

1138

How is character variable converted into numeric variable and vice versa?

1186

What do you know about symput and symget?

1269

Which function is used to count the number of intervals between two sas dates?

1142

Un-Answered Questions { Data Warehouse }

How do you truncate a table?

1186

Explain what are the possible data marts in retail sales?

1029

What are the various indexes in teradata? How to use them? Why are they preferred?

1077

What is heterogeneous mapping?

1090

Can anyone tell me the new features in Informatica 9 Version?

2150

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2203

Explain what are non-additive facts in detail?

1050

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

932

What are prompted filters?

951

Give the advantages of cognos?

1052

What are the different components of powercenter?

1069

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2249

Design a mapping to load the cumulative sum of salaries of employees into target table?

1516

Explain fact table?

1064

update strategy transformation in informatica

1077

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