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

How to load duplicate records in to a target table which has a primary key?

2 7875

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

Wipro,

3 7412

In a Single page we are having 3 list. While running each has to populated in separate page?

TCS,

2 6435

A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 4933

what is 'reconsideration error' and how can i respond to this error and how to debug this

Wipro,

2634

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

Wipro,

2 8205

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

Accenture,

5 16434

what is data modelling? what are types of modelling?In which suituation will use each one?

Accenture,

1 13413

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 8022

what is optional prompt in boxi r2

Mind Tree,

4 11604

what is BIAR file in business objects xi r2

TCS,

3 19572

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

Honeywell,

1 5550

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

HP,

2 8299

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

Wipro,

1 5261

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2308

Un-Answered Questions { Data Warehouse }

What is real time and near real time data warehousing?

1120

What is the main difference between inmon and kimball philosophies of data warehousing?

1119

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

990

What is a general purpose scheduling tool?

1118

Mention what are the data types does SAS contain?

1155

How to create different types of templates?

991

What do you mean by derived metrics?

1001

What is metadata in context of a datawarehouse and how it is important?

1052

How to create a non-reusable instance of reusable transformations?

1136

Define repository tables in datastage?

1164

how will you location sas platform applications available from web browser? : Sas-bi

1080

What is difference between page break and section report?

1216

Explain dimension table ?

987

What does sleep function does in fast load?

1145

What is the purpose of trailing @ and @@? How do you use them?

1042

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