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 7109

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

L&T,

2 7342

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 10616

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 30699

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

ABC, Amex,

11 34229

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

 1 6461

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 9212

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

Bank Of America,

2 10400

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

 8 16567

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 8440

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

HCL,

14 16498

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

1 3603

what do you mean by parallel execution of query?

Mind Tree,

1 4886

Un-Answered Questions { Data Warehouse }

Explain where to store informatica rejected data? How to extract the informatica rejected data?

574

how do you manage the production space. what are the proactive methods you can take ?

1473

What do you mean by drill across?

573

What is meant by lookup transformation? Explain the types of lookup transformation?

565

List some pros and cons of amazon redshift?

1




what are the production issues in datastage?

9734

define cognos reporting tool?

5

What is the size of the cube?

533

Write various indexes used in cognos?

552

any difficulitis have you phase while creating bo reports and how did u solve it

2988

While importing the relational source definition from the database, what are the metadata of source that will be imported?

782

What is a sorter transformation?

652

Explain joiner transformation in informatica

664

What function should we use to display the value entered or selected by a user in response to a prompt?

510

What is the difference between junk dimension and degenerated dimension?

554

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