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?

1076

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

1075

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

1213

Explain how merging helps to combine data sets.

1055

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

1040

Explain what is data step?

1206

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

1299

What are the differences between proc means and proc summary?

1144

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

1366

Mention what is the difference between nodupkey and nodup options?

1012

What are the default statistics for means procedure?

1245

How does proc sql work?

1092

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

1087

What are the steps involved in creating dimensional modeling process?

1021

What is the difference between agglomerative and divisive hierarchical clustering?

1186

Un-Answered Questions { Data Warehouse }

What is union transformation in informatica?

1146

What are the different types of partition components in abinitio?

1350

What are the important features of datastage?

1127

What is Redshift Enhanced VPC Routing?

give the options which are available after importing data using ti?

How necessary is it to be creative in your work?

2476

Ist the schema that a data warehouse system can implements.

941

In abinitio, what types of parallelism are used?

1091

If informatica has its scheduler why using third party scheduler?

1268

What is the difference between hashfile and sequential file?

1261

Differentiate between Join, Merge and Lookup stage?

1094

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1906

how does sas handle missing values in sort order? : Sas programming

920

What is afc?

979

Why need staging area database for dwh?

1081

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