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 are the important features of datastage?

1063

Can you define merge?

1070

What are the different types of lookups in datastage?

1019

What are the different options associated with dsjob command?

1389

What is meta stage?

1140

What is the difference between datastage and datastage tx?

1020

What are the some differences between 7.x and 8.x version of datastage?

1218

What is the difference between an operational datastage and a data warehouse?

1098

What is the command line function to import and export the ds jobs?

1105

How you can fix the truncated data error in datastage?

1695

Define tm1 architecture?

Why did ibm cognos tm1 web change the technology from .net to java?

Can tm1 web be set up for load balancing?

Where is tm1 web logging information found?

Can you explain cognos tm1?

Un-Answered Questions { Data Warehouse }

How to use pmcmd utility command?

985

What is confirmed fact in dataware housing?

6847

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2020

Which sql query platform are you using to communicate with redshift?

What are the reusable transformations?

1110

What is usage analysis in datastage?

1275

Explain fact table?

992

----------------Describe DWH Architecture?

2020

What are the different ways to implement parallel processing in informatica?

1359

How to manage date conversion in Datastage?

1081

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3424

What is aggtorec restructure operator?

1368

How conflicts occur and what are the ways to resolve them?

898

define galaxy repository in informatica

2170

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

1059

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