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

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1118

What are the various indexes in teradata? How to use them?

1036

How do you design aggregate tables using teradata?

1 1737

What happens in a conflict? How do you handle that?

1064

What are the various indexes in teradata? Why are they preferred?

1022

Explain teradata utilities. What is multiload, fast load, tpump?

1024

What are aggregate tables? How do you design them using teradata?

1184

What is spool space? Why do you get spool space errors?

1038

What are default access rights in teradata? What explicit right can be given to a user?

1120

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

999

What are the various indexes in teradata?

1065

Explain teradata architecture in detail with a diagram.

1135

How would you load a very large file in teradata in general?

1045

Why do you get spool space errors? How do trouble-shoot them?

1070

Explain and compare pros and cons of snow flake schemas?

1044

Un-Answered Questions { Data Warehouse }

What is Data Vault???

2757

How many dimensions are there in informatica?

1103

Can I access intelligent cubes without olap services?

1071

What is a datastage job?

1028

Give some information on report bursting?

1008

Write the different tools in the workflow manager?

1083

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1206

How to handle decimal places while importing a flatfile into informatica?

1202

What are stage variables and constants?

1159

Explain attribute role?

1103

Can you execute a macro within a macro? Describe. : sas-macro

1123

What is a mapping?

1000

Are you involved in writing the inferential analysis plan? Tables specfications?

2577

What are some prerequisites for datastage?

1112

dimension object created in oracle can be imported in designer?how?

3001

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