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 a three-tier data warehouse?

1116

Difference between stored procedure and macro?

1173

What is multi insert?

1053

Different phases of multiload?

1016

What is the maximum number of dml can be coded in a multiload script?

1109

Did you write stored procedures in teradata?

1132

What is inner join and outer join?

1111

How to view every column and the columns contained in indexes in teradata?

1056

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1241

What is the use of having index's on table?

1 2454

Difference between inner join and outer join?

1028

What are the functions of a teradata dba?

1078

What are the various reporting tools in the market?

1072

How to identify ppi columns?

1180

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1109

Un-Answered Questions { Data Warehouse }

generate date / time dimension in informatica

1126

what is the difference between filter and condition?

1067

How to limit the max no of rows retrieved in the report?

984

What are the different types of data warehousing?

957

How to limit decimal places for variable using proc means?

1113

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

992

What are aggregate transformation?

1038

what are the dimensions that you have in your current project?list them?

2024

Can we create multiple integration service on single repository?

1188

Different sorts of metadata that stores in the storage facility?

1013

Explain informatica architecture - version 8 / 9

1093

What are the steps involved in designing a fact table?

891

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373

EXPLAIN SCD

1408

How will you generate test data with no input data?

1175

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