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 session partitioning?

1879

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 16322

Identifying the bottlenecks in various components of Informatica and resolving them.

1932

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 4195

what is pmrep command?

1 11577

what happens if the info.server doesn't find the session parameter in the parameter file?

1 5494

Can u access a repository created in previous version of Informatica?

1860

Eliminating of duplicate records without using dynamic lookups

3 7805

what are Lookup caches options? Including persistent caches.

1 4833

Difference between flat files and relational sources?

2 6256

what is session partitioning?

2129

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 7276

Identifying the bottlenecks in various components of Informatica and resolving them.

2618

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 8387

what are the different forms of normalization?

2 5774

Un-Answered Questions { Data Warehouse }

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2129

Explain about ab initio’s dependency analysis?

1168

How to handle decimal places while importing a flatfile into informatica?

1192

What are the various kinds of the hash file?

1149

What is the sequence generator transformation in informatica?

1184

What is fact degradation?

976

Is possible to create skid in dim,fact tables?

2636

Define joiner transformation?

1049

How do you import and export data into datastage?

1234

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2121

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910

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

1267

What is the Rank index port in Rank transformation?

1061

what are the concerns of OLTP and DSS systems?

1962

What are snapshots?

980

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