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 MPP. Is Redshift support MPP?

What is Redshift Enhanced VPC Routing?

How many types of nodes supported by Redshift and what are the functions of nodes?

Which sql query platform are you using to communicate with redshift?

Is Redshift a row based storage or columnar based?

For which purpose Redshift is used for ?

What are the important Features of Redshift?

What is Redshift Spectrum?

Explain what is redshift?

How can I load my data into Amazon Redshift from different data sources like Amazon RDS, Amazon DynamoDB and Amazon EC2?

Can we access the compute node of Redshift directly ?

What is the command used to find missing values?

1107

What is slibref?

1286

What is run-group processing?

1173

How would you identify a macro variable?

1097

Un-Answered Questions { Data Warehouse }

How to load the data from a flat file into the target where the source flat file name changes daily?

1067

What could be the possible resons of locks by user?

1096

Name few SAS functions?

1101

Does microstrategy intelligence server run on windows®, unix®, or linux®?

978

How do you import and export data into datastage?

1242

Distinguish between informatica & datastage. Which one would you choose and why?

1010

What interface is used to connect to windows based applications?

1116

How to eliminate duplicate rows from flat file?

944

What are the types of hierarchies?

1026

What is informatica? Why do we need it?

1108

What is the maximum length of the macro variable? : sas-macro

1101

For which purpose Redshift is used for ?

Explain what is informatica metadata and where is it stored?

1052

What are aggregate tables? How do you design them using teradata?

1176

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1113

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