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

Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com

2 5931

Can anybody tell me the difference b/w canned and adhoc reporting?.

5 63436

How to do performance tuning on reports.

3 14647

# how to increase logical sige of a table in microstrategy

1 9345

what is #prompt and #promptmany, runningtotal in report studio

1 9505

whatis the default data driven operation in informatica

2 7050

How to generate a single mapping for both the historical and incremental load.

CSC, TATA,

2 8599

How to eliminate 1st and last rows from the source and load the inbetween rows.

Syntel,

5 26451

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 5349

What are the uses of a Parameter file?

CSC,

3 13864

If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

CSC,

1 6725

How to handle multi value dimensions?

2364

What is Portal Tab?

1 4791

What is meant by report studio short cut?

2 7666

What is stitched Query?

5 33935

Un-Answered Questions { Data Warehouse }

Explain what is a three tier data warehouse?

1038

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1924

Explain normalization?

1208

Do you need to rearrange the order of the data for the report?

2363

What is defined as catalog and types of catalogs in Cognos?

1206

What are the types of containers and how to create them?

1034

What is meta data and system catalog?

2347

Compare etl & elt?

1062

differentiate between power play transformer and power play reports?

What are the different versions of sas that you have used until now? : sas-grid-administration

1396

Diff b/w Crossproduct and Outerjoin?

2339

what is difference between drill & scope of analysis?

1173

Can you define materialized view?

1110

Explain the difference between etl tool and olap tools?

969

explain how to create powerplay reports?

1071

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