Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

Cap Gemini,

1558

what is granularity in Data ware House?

IBM,

1 1812

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

Cap Gemini,

1 2505

What is the difference between project backlog and product backlog?

IBM,

1 1641

SCD2 will work on only dimension tables as well as fact Table?

Infosys,

1 1471

Which transformation we use to convert 'NA' to 'Not Available'

1 1327

Un-Answered Questions { Data Warehouse }

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

Explain how to generate iqd file from framework manager?

1021

Have you have ever worked in unix environment and why it is useful in datastage?

1214

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2262

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2208

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

What sort of existing documents should business analysts refer to when starting on a new project?

1078

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Hi, If anyone has base SAS certification dumps, please share.

1937

Hi friends, what are the new features in abinito3.0?

2860

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