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?

1025

Mention a few design and development best practices for informatica?

1007

How can we store previous session logs?

1094

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

1105

How an expression transformation differs from aggregator transformation?

1048

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

1098

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

1145

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?

982

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

1216

What is xml source qualifier transformation in informatica?

1228

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?

1182

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

1036

What do you understand by term role-playing dimension?

1061

What is parallel processing in informatica?

1721

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

960

Un-Answered Questions { Data Warehouse }

Explain the scenario which compels informatica server to reject files?

1174

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

2077

How etl testing is different from database testing?

1061

What exactly do you understand with the term data processing and businesses can trust this approach?

1120

Explain about a time when you discovered a more efficient way to do a work task?

1164

7. What is performance tuning?

2005

Is it possible to join multiple Databases in a Catalog?

1134

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1925

How can you set the session management?

1132

What is metadata in context of a datawarehouse and how it is important?

1055

What are the mapping parameters and mapping variables?

1211

What are the steps to build the datawarehouse?

1047

How do you convert single row from source into three rows into target?

1172

What are the ways to import data into catalog?

1094

Did you write stored procedures in teradata?

1141

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