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 7622

what is left outer join?

L&T,

3 8635

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

L&T,

2 8517

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 12835

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 34974

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

ABC, Amex,

11 38464

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

1 7199

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 11267

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

Bank Of America,

2 11949

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

8 19227

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

2824

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 10204

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

HCL,

14 21540

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

1 4590

what do you mean by parallel execution of query?

Mind Tree,

1 5680

Un-Answered Questions { Data Warehouse }

How to get sql from obiee for reports?

942

How to pivot row data using informatica?

1020

How to call shell scripts from informatica?

1045

How many types of hash files are there?

1248

What are the advantages of query studio compared to report studio?

962

why use references rather than pointers in the public api, particularly for arguments which are modified?

1063

Differentiate primary key and partition key?

1038

What are the types of data warehouses?

1589

difference between repository database and repository service?

1233

Can you define drill down and drill up?

1089

What is a local lookup?

1275

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1173

What is the difference between Active and Passive transformation?

1235

What needs to be done while starting the database?

1166

how many types of dimensions are available in informatica?

1201

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