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 is diffence between query calculation and layout calculation?

4 23021

What data sets do you need to produce the report?

Novartis,

2 7441

How are the analysis data sets structured?

3 6764

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2255

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?

3 7220

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1925

Do you need to rearrange the order of the data for the report?

2311

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2343

What are the differences between TerdataV2R5 and V12 Versions please??

3 7238

how to schedule a report for even number dates?

HCL,

2 6714

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

HCL,

5 12910

WHAT IS SYNCHRONIZATION IN BOXI?

HCL,

2 9898

Approximatly how many enduser can use the each bo project?

HCL,

4 8299

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

IBM, Polaris,

3 12567

what is difference in window SAS & Unix SAS.....how do define working environment in both???

JPMorgan Chase,

1 10366

Un-Answered Questions { Data Warehouse }

What are orabulk and bcp stages?

1133

----------------Diff b/w Dimensional modeling and Relational modeling?

15018

for whom is sas data integration studio designed? : Sas-di

1012

If RDBMS is halted what will you do ?

2177

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2015

Define mapplet?

1019

Explain the informatica workflow?

1078

Explain true primary keys?

1008

What are the automatic variables for macro? : sas-macro

1264

What all the types of jobs you developed?

1183

What are the different type of jobs in datastage?

1046

Explain the difference between view and materialized view?

949

Explain input and put function?

1148

What is percent-to-total shortcut metric in microstrategy?

983

In how many ways we can create ports?

1130

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