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?

1277

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

1305

In ARRAY processing, what does the DIM function do?

1232

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

1132

explain the environment varaibles with example?

1142

Have you used rollup component? Describe how.

1124

What is the difference between sandbox and EME?

1314

What parallelisms does Abinitio support?

1266

What is a deadlock and how it occurs?

1202

How do you truncate a table?

1221

What is the difference between rollup and scan?

1932

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

1195

Explain the methods to improve performance of a graph?

1158

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

1308

Describe the Evaluation of Parameters order.

1 1939

Un-Answered Questions { Data Warehouse }

How to know the time taken for particular report execution?

1014

Define different types of attributes in microstrategy desktop?

1291

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4810

What is the function of model design accelerator?

1013

What are the types of folder present in cognos?

1142

What is difference between join, merge and lookup stage?

1156

Difference between Data and Index Caches?

1212

What is the function of parser component in teradata?

1137

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1974

What is embedded metric?

1057

How to generate sequence numbers using expression transformation?

1154

What is Data Caches size?

1133

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2092

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

985

Explain append procedure?

1134

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