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 9055

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

12 22287

How to get EVEN & ODD numbers separately?

8 26587

How to retrieve last two days updated records?

4 10825

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

15 21672

How to merge First Name & Last Name?

8 19358

How to display First letter of Names in Caps?

7 21751

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

Infosys,

16 44010

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

IBM,

2 6197

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

IBM,

2072

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

HCL, IBM,

1 5209

What is the difference between filter & Condition?

IBM, Polaris, TCS,

4 21104

What is the difference between macro & Parameter

IBM,

1 10555

what is an sid (surrogate key)?

IBM, Oracle,

2 6647

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

HCL,

6 10247

Un-Answered Questions { Data Warehouse }

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

Can you explain kafka connector?

1312

What is Session and Batches?

1108

What is the report studio?

1018

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2365

Explain why we use partitioning the session in informatica?

1094

What is the basic syntax style in SAS?

1168

What is the difference between round-robin partitioning and hash partitioning?

973

Explain fact constellation schema?

1036

can you please explain me pre session and post session options?

7569

Explain which versions are used in the bo dashboard work?

1094

What is the difference between agglomerative and divisive hierarchical clustering?

1186

Which algorithm you used for your hashfile?

1182

What is metadata in microstrategy?

1116

Define ramp limit in ab initio?

1286

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