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

Please write codes to merge two datasets and keep every record in the first dataset.

1 4783

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 7012

Write a SAS macro to calculate number of numbers in an email address

2 6444

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 7235

Can i create a lookup table without cache.

iGate,

7 11654

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

iGate,

2201

whats the logic to load the lower level of granularity of data to fact table.

IBM,

2276

What exactly mentioned in High level design document.can somebody explain me sequentialy.

IBM,

1 6660

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

IBM,

2 5792

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

IBM,

1 3516

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

iGate,

1 5739

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 5500

how to find out number of records imported into source file?

1 6809

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

Cap Gemini,

4 12455

how to prepare the documentation in business objects and where to get the requirement?

IBM, TCS,

2223

Un-Answered Questions { Data Warehouse }

What is dimensional modelling?

986

How conflicts occur and what are the ways to resolve them?

949

How is the number of passes in a sql query significant in performance evaluation?

970

How a routine is called in datastage job?

1112

What are the features of complex mapping?

1161

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1268

What are the conditions needed to improve the performance of informatica aggregator transformation?

1094

State the difference between INFORMAT and FORMAT ?

1109

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

960

Explain fact constellation schema?

1037

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2212

What is your spectra photometer working principles?

982

What is the difference between class statement and by statement in proc means?

1300

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

What is critical column?

1186

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