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 23034

What data sets do you need to produce the report?

Novartis,

2 7450

How are the analysis data sets structured?

3 6775

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?

2257

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 7234

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

1930

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

2320

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

2354

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

3 7255

how to schedule a report for even number dates?

HCL,

2 6727

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

HCL,

5 12938

WHAT IS SYNCHRONIZATION IN BOXI?

HCL,

2 9913

Approximatly how many enduser can use the each bo project?

HCL,

4 8322

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 12585

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

JPMorgan Chase,

1 10372

Un-Answered Questions { Data Warehouse }

 Informatica Checkpoints

3341

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

1096

Explain the characteristics of cognos?

1054

What if the source is a flat-file?

1127

What are constraints and derivations?

1188

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1963

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3580

Can we override a native sql query within informatica?

1049

What are the other methods working as deployment functionality?

956

What kind of layouts does abinitio support?

1305

Can you explain the advantage of using shortcuts?

1045

What is hybrid slowly changing dimension?

1049

what is diff b/t sorter t/r and agg have the option sorter property...

2195

What is a materialized view log?

1007

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2288

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