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?

1036

What do you mean by the overflow errors?

1369

What are the factors on which storage of data depends?

1166

What kind of layouts does abinitio support?

1289

List out the file extensions used in abinitio?

1094

What are the different types of parallelism used in abinitio?

1111

Explain how abinitio eme is segregated?

1496

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

1437

How to run a graph infinitely?

1121

What are the benefits of data processing according to you?

1216

What is expression transformation?

1101

What are the different lookup cache(s)?

1118

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

1362

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

1115

How are indexes created after completing the load process?

1644

Un-Answered Questions { Data Warehouse }

What is an i-server? What are the different modes to run it?

978

What is a Pivot?

1148

What do high confidence, low confidence and no confidence mean in explain plan?

1048

Explain the term 'row' related to relational database management system?

953

can u any challenge your project?

2033

What is dimensional modelling?

985

Can we start and stop single session in concurent bstch?

941

What is substr function?

1190

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1157

What is a mapping?

988

Explain the difference between union and group?

1100

What is the use of report studio?

1031

What can we do to improve the performance of informatica aggregator transformation?

1095

What is metadata in microstrategy?

1113

what is broad cast agent? : Sas-bi

1071

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