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 to display null values on a target & non-null values on a target?

3 9077

How to extract original records at one target & Duplicate records at one target?

12 22347

How to get EVEN & ODD numbers separately?

8 26632

How to retrieve last two days updated records?

4 10849

In a table, 4 person having same salary. How to get Third person record only?

15 21765

How to merge First Name & Last Name?

8 19393

How to display First letter of Names in Caps?

7 21788

How to list Top 10 salary, without using Rank Transmission?

Infosys,

16 44105

how many types of keys are there i.e primary key and foreign key etc..?

IBM,

2 6213

what are the dimensions that you have in your current project?list them?

IBM,

2081

what is filter?give me one example that you created a report in your project?

HCL, IBM,

1 5224

What is the difference between filter & Condition?

IBM, Polaris, TCS,

4 21136

What is the difference between macro & Parameter

IBM,

1 10572

what is an sid (surrogate key)?

IBM, Oracle,

2 6672

write a query to display the third record from the employee table?

HCL,

6 10271

Un-Answered Questions { Data Warehouse }

What is the command used to run a batch?

1079

What is a rank transform?

1095

How can we update a record in the target table without using update strategy?

1160

which features do you use to check the data validations and errors? : Sas-administrator

1067

For faster process, what we will do with the universe?

1001

How to elaborate tracing level?

1193

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2231

What is the difference between Datastage 7.5 and 7.0?

1111

What is surrogate key? Explain with examples.

1172

What is dimensional modeling?

1101

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1811

What information is shared by the application across microstrategy web nodes?

1061

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1047

What is SAS? What are the functions does it performs?

1213

What is informatica? Why do we need it?

1119

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