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 sql query overwrite in source qualifier in informatica

Informatica,

1090

Why union transformation is an active transformation?

Informatica,

1047

What are the limitations of joiner transformation?

Informatica,

1114

Explain joiner transformation in informatica

Informatica,

1124

What are the informatica performance improvement tips

Informatica,

1093

What are the mapping parameters and mapping variables?

Informatica,

1204

To import the flat file definition into the designer where should the flat file be placed?

Informatica,

1060

How are the sources and targets definitions imported in informatica designer?

Informatica,

1107

What are the data movement modes in informatica?

Informatica,

1152

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

Informatica,

1074

Explain sql transformation in script mode examples in informatica

Informatica,

1132

What are Dimensional table?

Informatica,

1055

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

Informatica,

1106

While importing the relational source definition from the database, what are the metadata of source that will be imported?

Informatica,

1265

Explain the mapping variable usage example in informatica

Informatica,

1157

Un-Answered Questions { Data Warehouse }

Explain parsing engine in teradata?

1090

what are all the reports you generated in your recent project?

2199

Different qualification between a related rotate toward the sky and isolates look upward?

986

What is the precedence of stage variables,derivations, and constraints?

1086

Can anybody tell me what are the tuning problems?

2046

What is dimensional table? Explain the different dimensions.

1172

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

900

How does microstrategy object manager determine if two objects in different projects are the same?

1062

what is power prompt in cognos ep7series?what is the use of this?

3689

Can the administrator easily maintain and manage microstrategy intelligence server?

1000

What is the deployment requirements used in cognos?

1653

what is size of u r database?

2305

is data integration and etl programming is same? : Sas-di

1082

What is union transformation in informatica?

1146

What is difference between custom hierarchy and report based hierarchy?

1018

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