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 the basic structure of the SAS base program?

1420

Explain data step in SAS

1163

Explain what Proc glm does?

1308

What is the difference between nodupkey and nodup options?

1092

State the difference between INFORMAT and FORMAT ?

1158

What is a method to debug and test your SAS program?

1459

How you can read the variables that you need?

1179

Name types of category in which SAS Informats are placed?

1199

How far Redshift is better in performance as compare to other data warehouse technologies?

How we can scale Reshift database?

Select the AWS service which is nosql database and serverless, minimal latency ?

How do we load data into Redshift?

Is it possible to access Redshift compute Nodes directly?

How we can monitor the performance of Redshift data warehouse cluster.

How will I be charged and billed if I use Amazon Redshift?

Un-Answered Questions { Data Warehouse }

Is it possible to get a floating window in microstartegy web? If yes, how?

1216

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2171

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1560

what is sas data set?

1161

How many project sources we can create in metadata?

1171

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

1034

Explain the advantages of partitioned primary index in a query?

1085

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2082

What Amazon redshift built for ?

Describe implicit attribute?

1072

What is VLDB?

1119

What are the advantages of raid 1, 1/0, and

1030

What is the goal of optimizer?

1104

How many dimensions are there in informatica?

1141

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3354

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