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 node in Informatica?

1087

What is native users?

1227

How would you copy the content of one repository to another repository?

1065

What is an Integration service in Informatica?

1197

What is data movement mode in Informatica and difference between them?

1188

What is a code page?

1224

What is DR strategy for Informatica project?

1231

difference between repository database and repository service?

1229

Is it possible to define a single node as a Gateway node as well as worker node?

1188

Is it possible to create multiple domains on a single Informatica server?

1291

Can we create a node as a gateway node and the same node can be assigned to a grid?

1126

What is difference between a gateway node and worker node?

1206

Is it possible to revert a global repository to local one and why?

1143

How do you migrate data from one environment to another?

1152

Can we create two repositories on same database instance in oracle?

1147

Un-Answered Questions { Data Warehouse }

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1407

What are the operations that support avoiding duplicate record?

1492

which type of project we r going to snowflake schema

2027

what is a security filter?

1059

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1302

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1200

what is sas and what are the functions? : Sas-administrator

1037

How can we use mapping variables in informatica?

1125

What is the use of Amazon redshift ODBC driver ?

What is meant by a Least Cost Plan?

1116

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2251

How can users design dashboards quickly and without programming experience or training?

1012

Can you suggest us materials for sdtm mapping?

4496

Explain why are oltp database designs not generally a good idea for a data warehouse?

1085

How do you migrate data from one environment to another?

1152

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