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 5828

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

5 63171

How to do performance tuning on reports.

3 14501

# how to increase logical sige of a table in microstrategy

1 9267

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

1 9423

whatis the default data driven operation in informatica

2 6918

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

CSC, TATA,

2 8482

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

Syntel,

5 26228

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 5270

What are the uses of a Parameter file?

CSC,

3 13684

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 6630

How to handle multi value dimensions?

2297

What is Portal Tab?

1 4710

What is meant by report studio short cut?

2 7541

What is stitched Query?

5 33721

Un-Answered Questions { Data Warehouse }

What are the stages of datawarehousing?

1015

Highlight the differences between Primary Key and Primary Index.

1096

what is the use of server?

2203

What are the different options associated with dsjob command?

1443

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

2012

What is cfapplication tag?

976

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

967

As union transformation gives UNION ALL output, how you will get the UNION output?

1110

What are the features of complex mapping?

1162

What is the difference in creating filters in designer and business objects?

1030

Explain append procedure?

1090

Notification Activity

1415

What are aggregate tables? How do you design them using teradata?

1175

which features do you use to check the data validations and errors? : Sas-administrator

1061

What is type 2 version dimension?

979

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