1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

L&T,

2 6492

what is left outer join?

L&T,

3 7116

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

L&T,

2 7353

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 10618

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 30715

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

ABC, Amex,

11 34257

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

 1 6463

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 9233

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

Bank Of America,

2 10411

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

 8 16572

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

 2270

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 8450

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

HCL,

14 16514

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

1 3608

what do you mean by parallel execution of query?

Mind Tree,

1 4888

Un-Answered Questions { Data Warehouse }

What is a deadlock and how it occurs?

667

What are the settings that you use to configure the joiner transformation?

611

what techniques and/or procs do you use for tables? : Sas programming

572

What are the data types does SAS contain?

649

How can you define user defied event?

614




How do you load alternate records into different tables through mapping flow?

1286

Write types of folders present in cognos?

566

What is the purpose of interprocessor stage in server jobs?

1724

explain about balanced dimension,

559

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

571

What is the difference between partitioning with key / hash and round robin?

633

Explain BYNET.

602

What is metric store database?

565

What is the use of virtual processor connectivity in teradata?

563

which features do you use to check the data validations and errors? : Sas-administrator

544

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