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 to use consolidations in microstrategy report?

1 1106

how can you direct the sql generated to use a specifc table?

1 1033

What is static prompt in microstrategy?

1 1050

What are the various file formats involved in reportnet?

1 1055

Explain how many ways you create ports?

1 1095

Explain how to get the first 100 rows from the flat file into the target?

1 1050

Why should you put your data warehouse on a different system than your oltp system?

1 1086

Explain what are components of reportnet?

1 1052

Explain a relation schema and a relation?

1 1195

Explain what is the difference between stop and abort?

1 1108

What are components of report studio?

1 1157

What are the mapping paramaters and maping variables?

1 1099

What are the advantages of query studio compared to report studio?

1 970

Explain what is the extension of file to save template?

1 1039

What is the limit to the number of sources and targets you can have in a mapping?

1 1172

Un-Answered Questions { Data Warehouse }

How to create the source and target database connections in server manager?

1144

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

1200

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)

2795

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1673

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

847

Write the unconnected lookup syntax?

1152

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

1217

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

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

2107

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2549

explain in detail about type 3?

1091

what is document design in boxi,have u participate in that

2306

What is rollup component?

1337

What is aggregate table and aggregate fact table ... Any examples of both?

1119

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

1150

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