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?

1075

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

1073

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

1213

Explain how merging helps to combine data sets.

1054

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

1040

Explain what is data step?

1202

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

1299

What are the differences between proc means and proc summary?

1143

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

1365

Mention what is the difference between nodupkey and nodup options?

1009

What are the default statistics for means procedure?

1245

How does proc sql work?

1088

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

1085

What are the steps involved in creating dimensional modeling process?

1021

What is the difference between agglomerative and divisive hierarchical clustering?

1185

Un-Answered Questions { Data Warehouse }

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4371

What are the special input delimiters used in SAS?

1183

Explain what is the difference between business requirement document and use case document.

1021

Explain how to get the first 100 rows from the flat file into the target?

970

If you could design your ideal job, what would it look like?

2931

What is MPP. Is Redshift support MPP?

Explain is fact table?

932

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2188

What according to you might be the future of data warehousing?

1027

How to test the debugging in sas?

1179

what are the special features in cognos reportnet?

1061

Explain what is a three tier data warehouse?

975

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1956

Explain lookup transformation in informatica

1073

Define data aggregation?

1099

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