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 many project sources we can create in metadata?

1 1201

What is the difference between static cache and dynamic cache?

1 1083

ware house management system is used?

1 1071

What function should we use to display the value entered or selected by a user in response to a prompt?

1 1064

What are partition points?

1 1163

How can we transform row to column?

1 1565

How to stop a batch?

1 1044

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

1 1076

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

1 1032

Suppose we want to display zero when null values coming to report how can we do that?

1 1002

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

1 991

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

1 1027

How to test report in reportnet?

1 1070

What are aggregate transformation?

1 1111

Tell me what is degree of a relation?

1 1070

Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax?

1146

Explain how to generate iqd file from framework manager?

1021

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6076

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2793

What is the difference between business requirement document and use case document.

1081

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2262

Have you have ever worked in unix environment and why it is useful in datastage?

1214

How would you format some text using css to be verdana and bold?

1147

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

Explain in detail about scd type 1 through mapping.

1646

What is dimensional table?

1162

Hi, If anyone has base SAS certification dumps, please share.

1937

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