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 9195

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

12 22766

How to get EVEN & ODD numbers separately?

8 26877

How to retrieve last two days updated records?

4 11024

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

15 22208

How to merge First Name & Last Name?

8 19659

How to display First letter of Names in Caps?

7 22054

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

Infosys,

16 44691

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

IBM,

2 6311

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

IBM,

1 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 21273

What is the difference between macro & Parameter

IBM,

1 10631

what is an sid (surrogate key)?

IBM, Oracle,

2 6804

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

HCL,

6 10470

Un-Answered Questions { Data Warehouse }

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

what are the names of the reports that you prepared?

1185

What is dimensional table? Explain the different dimensions.

1262

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1839

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

What is the purpose of Dataware Control?

1110

what are the data modeling tools you have used?(polaris)

2054

What is dimensional table?

1145

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

Have you have ever worked in unix environment and why it is useful in datastage?

1210

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4183

Demonstrate experience in maintaining quality process standards?

2658

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