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

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

IBM,

1 5120

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 9004

What is diff joiner and lookup

BirlaSoft,

4 8621

what is mapping parameter and mapping variables

BirlaSoft,

1 5197

if i am having 10 records in source, i want 20 records in target...how will you do it

BirlaSoft, IBM,

13 18612

without matching columns in two tables. how can you join

BirlaSoft,

5 11531

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 5676

What is differnce between Error code and Error Level in Bteq

IBM,

6 39362

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

IBM,

6 21330

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

IBM,

4 8231

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 7838

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

what is crosstab space

IBM,

1 13573

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

Span Systems,

5 8326

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

Span Systems,

3 6388

Un-Answered Questions { Data Warehouse }

Differentiate between ceil and floor functions.

1162

How do you set a varible in incremental aggregation

1891

How can you force the optimizer to use a particular index?

1058

what is sas metadata repository? : Sas-bi

1117

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

836

Explain the term 'primary key' related to relational database management system?

1036

What is the difference between business requirement document and use case document.

1007

Describe an informatica powercenter?

1127

Where do you use proc means over proc freq?

1121

Define Dynamic push down optmization?

2301

what is a worklet?

994

What is Session and Batches?

1108

define cognos connection?

What is the importance of having monitor service in cognos?

1036

What is orabulk stage?

1047

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