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 4268

Tell me the syntax of Configuration file?

1 5008

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

2041

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

IBM,

1 3285

How do you design PX Routines ?

1 3403

What is the use of Row generator stage?

2 13291

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

4132

On which Dimension Table you implemented SCD Type in your Project

2054

How you Remove the Dataset in Unix?

5 21667

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

1 10919

What is the default padding character?

IBM,

3 15653

What are the partition techniques available in your last project?

1 5323

What is the default execution order of the sequential file?

3 13787

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

SS Solutions,

1 7015

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

6 27021

Un-Answered Questions { Data Warehouse }

Is redshift can be used with AWS RDS?

What are universe requirements?

1052

how we can load rejected record's at run time?(not through bad files)

2384

Is it possible to revert a global repository to local one and why?

1086

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

What is the limit to the number of sources and targets you can have in a mapping?

1110

Define Merge?

1324

What are the important features of datastage?

1129

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1173

How would you configure wh authentication?

956

define data tab?

What are the benefits of datastage?

1238

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1472

how to remove duplicates using proc sql?

1153

What are batches?

1107

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