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

How to specify variables to be processed by the freq procedure?

1043

Give some examples where proc report’s defaults are different than proc print’s defaults?

1019

If a variable contains letters or special characters, can it be numeric data type?

1168

Explain how merging helps to combine data sets.

1005

What is the purpose of trailing @ and @@? How do you use them?

1003

Explain what is data step?

1150

What is the difference between class statement and by statement in proc means?

1215

What are the differences between proc means and proc summary?

1086

What’s the difference between var b1 – b3 and var b1 — b3?

1291

Mention what is the difference between nodupkey and nodup options?

973

What are the default statistics for means procedure?

1186

How does proc sql work?

1034

If a variable contains only numbers, can it be a character data type?

1042

What are the steps involved in creating dimensional modeling process?

965

What is the difference between agglomerative and divisive hierarchical clustering?

1127

Un-Answered Questions { Data Warehouse }

What are the types of presistent cache in look up tr.

2022

Explain what are the various transformation available?

983

What are the settings that you use to configure the joiner transformation?

1017

Explain how we drill up week to month?

1050

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1014

What is meant by a Highest Cost Plan?

1004

What is the basic syntax for teradata select statement?

998

What is oci?

1264

Define different types of attributes in microstrategy desktop?

1173

Code check-in and check-out commands in AbInitio

4262

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1892

What are prompted filters?

880

Why are meta service important then other services?

923

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1728

Different phases of multiload?

948

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