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?

1093

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?

1100

What are the different lookup cache(s)?

1118

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

1361

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 }

How are the dimension tables designed?

1001

Could you explain what is enterprise data warehouse?

1148

how to sort two columns in single job in datastage.

2902

What is the difference between dependent data warehouse and independent data warehouse?

1007

What are the functionalities of link collector?

1085

what is slowly changing dimension? : Sas-di

1128

How does microstrategy object manager determine if two objects in different projects are the same?

1062

Your application mode has crashed. How would you get the instance back?

936

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1507

Differentiate primary key and partition key?

980

How do you optimize reports in microstartegy?

1109

What are the types of studio?

1150

what are the reporting tools and difference between them?

2090

Is there any way to read the ms excel datas directly into informatica?

1022

how do you debug and test your sas programs? : Sas programming

1124

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