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 7502

what is left outer join?

L&T,

3 8448

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

L&T,

2 8383

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 12562

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 34482

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

ABC, Amex,

11 37981

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

1 7121

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 11058

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

Bank Of America,

2 11781

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

8 18954

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

2762

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 9987

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

HCL,

14 20959

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

1 4500

what do you mean by parallel execution of query?

Mind Tree,

1 5586

Un-Answered Questions { Data Warehouse }

How substr function works in sas?

1222

What are the other names given to data warehousing?

1094

What is session task and command task?

1296

What do you mean by teradata intelliflex?

1104

Explain what is a three tier data warehouse?

975

What does level of granularity of a fact table signify?

1095

write a query to display the departments with no employee?

1971

Code the tables statement to produce a multi-level frequency?

1009

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

What is the commit type if you have a transaction control transformation in the mapping?

1030

Explain etl?

980

How we drill up week to month?

1077

Explain why denormalization is promoted in universe designing?

961

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1996

what can you learn from the sas log when debugging? : Sas programming

1089

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