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 mapping debugger?

1071

Mention a few design and development best practices for informatica?

1047

How can we store previous session logs?

1142

What can we do to improve the performance of informatica aggregator transformation?

1147

How an expression transformation differs from aggregator transformation?

1091

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1152

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1189

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1023

How does a rank transform differ from aggregator transform functions max and min?

1263

What is xml source qualifier transformation in informatica?

1278

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1233

What differs when we choose the sorted input for aggregator transformation?

1076

What do you understand by term role-playing dimension?

1124

What is parallel processing in informatica?

1799

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

Un-Answered Questions { Data Warehouse }

What are types of partition primary index (ppi) in teradata?

1109

what are the filters in framework manager and report studio?

1050

What is data mapping and data modelling?

1615

what are some good sas programming practices for processing very large data sets? : Sas programming

980

Suppose we do not group by on any ports of the aggregator what will be the output?

1101

How can I schedule reports in cognos?

1066

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1948

What is rank transformation in informatica

1237

What do you mean by static prompt report?

1038

What is the project in datastage?

1171

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097

What are common programming errors committed in sas

1190

What is non-aggregate metric?

1091

Explain what are the advantages and disadvantages of reporting directly against the database?

1061

What are the types of partitioning?

1085

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