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 the use of datastage director?

1033

What are routines in datastage? Enlist various types of routines.

1108

How do you remove duplicate values in datastage?

1164

Name the different sorting methods in datastage.

1070

What are routines in datastage?

1343

Is the value of staging variable stored temporarily or permanently?

1012

What are the different type of jobs in datastage?

1050

What is a quality stage?

1 1431

Enlist various types of routines in datastage.

1268

What are the different kinds of views available in a datastage director?

1045

What are the different common services in datastage?

1300

Where do the datastage jobs get stored?

1229

What are the processing stages?

1111

Give an idea of system variables.

1049

What are the various kinds of containers available in datastage?

1063

Un-Answered Questions { Data Warehouse }

how do u set partition points in the mapping?

2612

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1213

What is pre-emptive and non-pre-emptive?

995

how can we create rank using datastage?what is the meaning of rank?

8807

what is universe null

2433

How will you generate test data with no input data?

1185

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

963

explain about data integrator metadata reports? : Sas-di

1121

How can you link a query to a data container manually in Report Studio?

2370

How do you create tables? Exact syntax, and create profiles, users in teradata?

1051

What are the limitations for memory allocation for SAS variables

1510

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

975

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

1378

What is a mapplet/worklet in informatica?

1200

Define olap designer?

1142

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