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 9190

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

12 22755

How to get EVEN & ODD numbers separately?

8 26868

How to retrieve last two days updated records?

4 11016

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

15 22201

How to merge First Name & Last Name?

8 19642

How to display First letter of Names in Caps?

7 22043

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

Infosys,

16 44673

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

IBM,

2 6309

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

IBM,

2122

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

HCL, IBM,

1 5294

What is the difference between filter & Condition?

IBM, Polaris, TCS,

4 21270

What is the difference between macro & Parameter

IBM,

1 10628

what is an sid (surrogate key)?

IBM, Oracle,

2 6800

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

HCL,

6 10466

Un-Answered Questions { Data Warehouse }

CHANGE CAPTURE

1365

What is process model?

2032

SCD2 will work on only dimension tables as well as fact Table?

1469

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1085

what is the difference between microstrategy and cognos?

983

What is the complex report you faced in real time?

2237

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2053

differentiate between two-tier, three-tier and four-tier connections.

1047

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1821

What is a sorter transformation?

1167

Briefly describe lookup transformation?

1101

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2146

Describe 5 ways to do a “table lookup” in SAS?

1199

----------------Diff b/w Dimensional modeling and Relational modeling?

15117

what are the categories that sas informats are used to the place the data? : Sas-administrator

1104

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