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 5933

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

5 63444

How to do performance tuning on reports.

3 14651

# how to increase logical sige of a table in microstrategy

1 9347

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

1 9506

whatis the default data driven operation in informatica

2 7052

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

CSC, TATA,

2 8602

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

Syntel,

5 26454

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 13869

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 6729

How to handle multi value dimensions?

2364

What is Portal Tab?

1 4792

What is meant by report studio short cut?

2 7667

What is stitched Query?

5 33937

Un-Answered Questions { Data Warehouse }

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1344

How to limit decimal places for the variable using proc means?

1127

What are the different types of parallelism in ab initio?

1276

What you know about transaction control transformation?

1062

What are the steps involved after the disk manager passes the request?

1188

What do you mean by teradata intellicloud?

1079

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

1024

Where the applications and where ware house management system is used?

1059

How to hide certain columns from a user?

895

Define repository tables in datastage?

1216

How to design file watch jobs?

1025

What is usage analysis in datastage?

1367

Within a cursor, how would you update fields on the row just fetched?

1127

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1308

give the options which are available after importing data using ti?

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