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

Explain usage analysis in datastage?

1169

What is size of a transaction and an array means in a datastage?

1315

How many types of views are there in a datastage director?

1288

Why we use surrogate key?

1235

Define oconv () and iconv () functions in datastage?

1416

Name the third party tools that can be used in datastage?

1076

Define ds designer?

1282

Differentiate between odbc and drs stage?

1050

How do you find the number of rows in a sequential file?

1 3761

Why do we use link partitioner and link collector in datastage?

1137

How can one find bugs in job sequence?

1414

Differentiate between operational datastage (ods) and data warehouse?

1178

Differentiate between datastage and datastage tx?

1051

Why does microstrategy object manager search for object dependencies?

971

What is level metrics in microstrategy?

1031

Un-Answered Questions { Data Warehouse }

What are the some differences between 7.x and 8.x version of datastage?

1256

Highlight the main features of datastage?

1160

Explain the different dimensions.

967

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

961

What is package in BO

3203

What are diagrams?

1042

define drill through?

How analytics process your request when you create your requests?

938

What you will do when your report is not fetching right data?

929

Where $mpjret is used in ab-initio?

1146

How to limit decimal places for the variable using proc means?

1071

update strategy transformation in informatica

1065

What is the function of Stop statement in a SAS Program?

1153

can you please explain me pre session and post session options?

7570

Explain me ETL project architecture in Detail?

2371

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