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 16319

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 4193

what is pmrep command?

1 11575

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

1 5490

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

1860

Eliminating of duplicate records without using dynamic lookups

3 7802

what are Lookup caches options? Including persistent caches.

1 4826

Difference between flat files and relational sources?

2 6253

what is session partitioning?

2127

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 5772

Un-Answered Questions { Data Warehouse }

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2695

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2585

Why teradata is used?

1006

where to use sas business intelligence? : Sas-bi

1086

Mention common programming errors committed in sas ?

1125

What are session timeout and application timeout?

1018

--------------Explain Table of contents?

2024

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1015

What is the architecture of abinitio?

1096

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

949

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

What are the transformations that are not supported in mapplet?

1026

Explain factless facts?

982

How do you delete duplicate observations in sas?

1072

what are the reporting tools and difference between them?

2090

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