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 5119

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 9003

What is diff joiner and lookup

BirlaSoft,

4 8619

what is mapping parameter and mapping variables

BirlaSoft,

1 5196

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

BirlaSoft, IBM,

13 18608

without matching columns in two tables. how can you join

BirlaSoft,

5 11527

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 5674

What is differnce between Error code and Error Level in Bteq

IBM,

6 39359

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 21327

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 8230

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

2517

what is crosstab space

IBM,

1 13571

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 8321

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 6384

Un-Answered Questions { Data Warehouse }

Explain batch?

967

Can you generate sequence numbers without using the sequence generator transformation?

1119

What is the multi-insert?

1032

What is the difference between power center and power mart?

1021

How to create Index to the table in the universe designer and how it improves the Query performence

2551

What do you mean by dimensional modeling and relational modeling?

889

How and where you used hash file?

1172

what is chore commit property?

what is hints in cognos and where we use it.

2455

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1954

difference between impromptu and cognos8

2438

Can you explain cognos tm1?

What are the different types of parallelism in ab initio?

1221

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1240

Design time, run time. If you don't create parameter what will happen

1837

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