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

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1094

What do you mean by the overflow errors?

1436

What are the factors on which storage of data depends?

1207

What kind of layouts does abinitio support?

1368

List out the file extensions used in abinitio?

1130

What are the different types of parallelism used in abinitio?

1157

Explain how abinitio eme is segregated?

1566

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1485

How to run a graph infinitely?

1162

What are the benefits of data processing according to you?

1272

What is expression transformation?

1148

What are the different lookup cache(s)?

1170

In informatica workflow manager, how many repositories can be created?

1441

In informatics server which files are created during the session rums?

1171

How are indexes created after completing the load process?

1727

Un-Answered Questions { Data Warehouse }

How can we load the time dimension?

1252

What is the difference between one to one merge and match merge? Give an example.

1123

Explain and compare pros and cons of start schemas?

1153

What is informatica?

1221

What are the possible data marts in retail sales?

1064

What are the different versions of informatica?

1338

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1105

What are the different uses of a repository manager?

1180

Could you explain what is enterprise data warehouse?

1229

If you could design your ideal job, what would it look like?

2985

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1937

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1063

what type of graphs we will create(for 2+years candidates)?

2364

What is different between the data warehouse and data mart?

1114

Explain is there any default username & pwd for bo designer & supervisor?

1063

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