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?

1098

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

1243

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

1233

Why we use surrogate key?

1160

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

1345

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

1024

Define ds designer?

1221

Differentiate between odbc and drs stage?

1000

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

1 3663

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

1078

How can one find bugs in job sequence?

1319

Differentiate between operational datastage (ods) and data warehouse?

1122

Differentiate between datastage and datastage tx?

1008

Why does microstrategy object manager search for object dependencies?

930

What is level metrics in microstrategy?

937

Un-Answered Questions { Data Warehouse }

what is sas business intelligence? : Sas-bi

1102

What is the difference between Data Warehousing and Data Mining?

985

What is a materialized view log?

951

What is Additive function?

1978

define tm1 package connector?

Explain and compare pros and cons of start schemas?

978

------------ Diff b/w MemberCaption and MemberDescription?

2275

Of all your work, where have you been the most successful?

4625

What is data _null_?

1082

What information does a .dbc file extension provides to connect to the database?

1174

What is workflow monitor?

1000

Do you know what a local lookup is?

1140

define junk dimension?

Mention what dedup-component and replicate component does?

985

Explain the term 'columns' related to relational database management system?

995

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