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 many Nodes configuration file you used in your last project?

1 4365

Tell me the syntax of Configuration file?

1 5075

Explain the situation where you have applied SCD in your project?

2090

What are the third party tools you used in your project?

IBM,

1 3387

How do you design PX Routines ?

1 3489

What is the use of Row generator stage?

2 13414

How you Implemented SCD Type 1 & Type 2 in your project?

4181

On which Dimension Table you implemented SCD Type in your Project

2118

How you Remove the Dataset in Unix?

5 21900

What is the difference b/w Hash file and Lookup Fileset stages?

1 11013

What is the default padding character?

IBM,

3 15831

What are the partition techniques available in your last project?

1 5412

What is the default execution order of the sequential file?

3 13966

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

SS Solutions,

1 7090

How many input links can you give to a Transformer stage?

6 27223

Un-Answered Questions { Data Warehouse }

What is set to be cardinality?

1234

What could be the possible resons of locks by user?

1146

what is metadata? : Sas-bi

1080

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

2022

How to call shell scripts from informatica?

1045

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

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1850

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

1002

Explain the difference between holap and molap?

1110

-------------How you design DWH?

2370

How would you increase the logical size of a table in microstrategy?

1026

Can we override a native sql query within informatica?

1094

For clinical entire study how many tables will create approx?

2022

what is the meant by Normalization and de-normalization?

2773

how to insert/update a csv file by comparing it with another csv file?

2629

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