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

can we see default group,when we use router?if yes how?

L&T,

2 7506

what is left outer join?

L&T,

3 8462

when we use dynamic lookup,if condition matches what will be the o/p?

L&T,

2 8386

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

L&T,

5 12573

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

L&T,

11 34503

how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?

ABC, Amex,

11 38015

What are the differences between cognos 8.2 and cognos 8.4? Please help me..

1 7132

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

CTS, Wipro,

6 11063

Target is zero file and how can you send the email?

Bank Of America,

2 11789

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 18978

Is there any difference in testing database and data ware housing?

2768

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

Patni,

5 10000

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

HCL,

14 20999

working of line item dimension......pls,tell overall flow

1 4501

what do you mean by parallel execution of query?

Mind Tree,

1 5591

Un-Answered Questions { Data Warehouse }

what is universe null

2429

For what purposes have you used sas macros? : sas-macro

1001

Suppose we do not group by on any ports of the aggregator what will be the output?

1046

Explain fact constellation schema?

1046

What are the six data process products of ab initio (architecture of ab initio)?

1119

How can you import tables from a database?

1092

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1970

What are the stages of datawarehousing?

1015

What are the differences between star and snowflake schema?

1110

How to load data in informatica ?

1027

: and & modifiers.

1399

What system options would you use to help debug a macro? : sas-macro

1102

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

2423

What is DR strategy for Informatica project?

1193

How to test a cube?

2202

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