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

can we perform checkin and checkout through sandbox?

1184

What is data mapping and data modelling?

1560

What is the difference between check point and phase?

1313

What is MAX CORE of a component?

1323

What are the operations that support avoiding duplicate record?

1451

What are the Types of parallelism in detail?

1146

State the working process of decimal_strip function?

2163

What is the function that transfers a string into a decimal?

1166

How do you add default rules in transformer?

1231

How do you improve the performance of a graph?

1152

Explain PDL with an example?

1328

State the first_defined function with an example?

1 7964

What are the Graph parameter?

1164

What is the function you would use to transfer a string into a decimal?

1224

explain checkin and checkout?

1148

Un-Answered Questions { Data Warehouse }

Explain about core dimension,

994

What is primary and backup node?

1137

explain the difference between proc means and proc summary?

1131

Explain entity, attribute and relationship in datastage?

1111

What is a predefined event?

1097

How to read multiple files using a single datastage job if files have the same metadata?

1253

What are the three tiers in etl?

1115

which r the connectors used in san?

2189

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1209

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191

What are the primary characteristics of the Teradata.

1166

What is the maximum number of dml can be coded in a multiload script?

1110

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2389

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1036

What is mean by aggregate aware?

1096

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