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?

1229

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

1071

What is an Integration service in Informatica?

1206

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

1190

What is a code page?

1225

What is DR strategy for Informatica project?

1237

difference between repository database and repository service?

1233

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?

1296

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

1132

What is difference between a gateway node and worker node?

1214

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

1146

How do you migrate data from one environment to another?

1160

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

1150

Un-Answered Questions { Data Warehouse }

What is a transaction control transformation?

1270

Can you define cognos decision stream?

1046

What are the types of jobs we have in datastage?

1132

Please let me know how to make encryption and decryption with example?

1956

What is tracing level?

1143

Explain in detail about scd type 1 through mapping.

1639

Explain the use of aggregator cache file?

1330

What are the applications primarily used by business analyst? : Sas-bi

1055

What are the benefits of using AWS Redshift?

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1160

What are the different functions included in the server software?

1091

In BTEQ, how are the session-mode parameters being set?

1203

What is the need for an etl tool?

1107

how do u catch bad rows from OCI stage? And what CLI stands for?

2859

What is the difference between mapping parameter & mapping variable in data warehousing?

1055

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