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

Approximately what date is represented by the SAS date value of 730?

1219

How do you control the number of observations and/or variables read or written?

1259

In ARRAY processing, what does the DIM function do?

1179

How would you determine the number of missing or nonmissing values in computations?

1076

explain the environment varaibles with example?

1084

Have you used rollup component? Describe how.

1076

What is the difference between sandbox and EME?

1271

What parallelisms does Abinitio support?

1211

What is a deadlock and how it occurs?

1168

How do you truncate a table?

1176

What is the difference between rollup and scan?

1879

State the relation between EME, GDE and Co-operating system?

1141

Explain the methods to improve performance of a graph?

1111

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

1261

Describe the Evaluation of Parameters order.

1 1865

Un-Answered Questions { Data Warehouse }

Differentiate between operational datastage (ods) and data warehouse?

1183

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1328

Explain about hash partitioning?

1004

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2575

explain html document?

1020

Explain the different kinds of facts.

987

What is percent-to-total shortcut metric in microstrategy?

980

name the function which is used to serialize the ti process?

What does de-partition mean in abinitio?

1284

Tell me about Dnamic and Static Dashboards?

2348

What is the good sas programming practices for processing large data sets?

1127

Explain incremental aggregation in informatica

1137

What is upsert statement in teradata?

1142

Explain which versions are used in the bo dashboard work?

1097

What is metadata in microstrategy?

1123

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