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 ibm datastage?

981

Explain ibm infosphere information server and highlight its main features?

1105

Describe the main features of datastage?

1088

Explain connectivity between datastage with datasources?

994

What is the importance of the exception activity in datastage?

1082

What is the difference between informatica and datastage?

1240

What is the use of hoursfromtime() function in transformer stage in datastage?

1078

Describe the architecture of datastage?

1026

Describe link sort?

1021

What is ibm datastage flow designer?

1161

What are operators in datastage?

1 2084

What is a ds designer?

1080

How do you run datastage job from the command line?

1104

Can you explain data flow graph with an example?

1247

The methods to improve performance of a graph?

1090

Un-Answered Questions { Data Warehouse }

Under which circumstances, informatica server creates reject files?

1109

What is the difference between datastage and informatica?

1129

What is data analysis?

973

Explain your project of banking domian.

1658

Explain piconet?

970

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1753

What is etl process. How many steps etl contains explain with example?

970

Compare dataset and fileset?

1052

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 ?

2197

What is metadata in microstrategy?

1128

In Which Transformation We Can Use Having Clause In Informatica?

1258

How to generate or load values in to the target table based on a column value using informatica etl tool.

1085

On which Dimension Table you implemented SCD Type in your Project

2064

During the running session, output files are created by informatica server. Enlist few of them.

994

What is the ab initio business rules environment (bre)?

1185

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