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?

1880

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

5 16327

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

1935

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

1 4198

what is pmrep command?

1 11583

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

1 5497

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

1860

Eliminating of duplicate records without using dynamic lookups

3 7807

what are Lookup caches options? Including persistent caches.

1 4835

Difference between flat files and relational sources?

2 6261

what is session partitioning?

2135

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

2 7279

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

2619

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

2 8390

what are the different forms of normalization?

2 5778

Un-Answered Questions { Data Warehouse }

Explain teradata utilities?

1042

Explain the main difference between the sas procedures and functions? : Sas-administrator

1073

give the options which are available after importing data using ti?

Write the different types of matrices in microstrategy?

1017

What is a staging area? What is the purpose of a staging area?

885

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2495

What are the steps involved in etl process?

1028

in sap bi we have wad, then why we go for sap bo

3381

What are the data types present in bo?

1129

Explain can a dimension table contains numeric values?

968

What do you understand by the term 'model durability'?

1015

what is the difference between == and eq in UNIX shell scripting?

1500

What are the considerations regarding performance kept in mind while setting up cognos?

968

What are the reasons for which business can trust the approach of data processing?

1186

What do you mean by data sorting?

1210

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