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?

1335

Explain data step in SAS

1107

Explain what Proc glm does?

1220

What is the difference between nodupkey and nodup options?

1044

State the difference between INFORMAT and FORMAT ?

1113

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

1381

How you can read the variables that you need?

1126

Name types of category in which SAS Informats are placed?

1155

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 }

what is the difference between querystudio in reportnet and cognos8

2138

What are the components of workflow manager?

1105

Mention some file extensions which are used in abinitio?

1125

Define metrics studio?

1049

how many types of dimensions are available in informatica?

1105

What is the use of powerhouse?

1092

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2780

What are the kinds of layouts does ab initio supports?

1003

State the working process of decimal_strip function?

2163

Is it possible to apply themes to microstrategy web? How?

933

What is a predefined event?

1097

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

988

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1040

What are multi-group transformations?

1114

What are the main services provided by application tier?

983

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