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

What is _n_?

22 62563

What is BOMain.Key?

Cognizant,

5 23354

What is domain? How many are there in a basic setup? What are they?

1 5358

When is the Repository created?

1 5645

Can we have multiple domains?

3 7427

How do you restrict access to rows of a database?

2 7912

What is a category?

3 7428

What do you mean by Object qualification?

3 15331

What is the size of data base?

2 7059

What is a loop? How can we overcome?

5 10090

What is a join? Explain different types of joins?

5 26480

What are Alerter, Filters, Breaks and Conditions?

2 8709

What is the difference between master-detail and Breaks?

3 14728

What is metrics?

2 6725

What is a Set?

1 5501

Un-Answered Questions { Data Warehouse }

What is incremintal loading?

1119

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1121

How can a transformation be made reusable?

1178

Difference between project merge and object manager?

1031

Explain how many ways you create ports?

1030

What is a deadlock and how it occurs?

1175

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1397

Define dimensions?

1026

To which project that prefix will set is to private project or public project or both?how and where to set?

1862

What are SAS/ACCESS and SAS/CONNECT?

1155

What is use Array size in datastage

1788

List any five applications of data warehouse.

948

What is a surrogate key?

1091

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1280

how will you locate the sas platform applications? : Sas-bi

1042

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