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?

1884

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

5 16334

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

1937

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

1 4206

what is pmrep command?

1 11586

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

1 5501

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

1863

Eliminating of duplicate records without using dynamic lookups

3 7817

what are Lookup caches options? Including persistent caches.

1 4840

Difference between flat files and relational sources?

2 6268

what is session partitioning?

2148

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

2 7281

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

2621

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

2 8396

what are the different forms of normalization?

2 5785

Un-Answered Questions { Data Warehouse }

How does microstrategy object manager determine if two objects in different projects are the same?

1072

What is the difference between view materialized view and view?

1077

what kind of system requirement is needed to run tm1 for a small installation?

explain what is factor analysis? : Sas-administrator

1118

Where is tm1 web logging information found?

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1170

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2133

how u will design the report if the objects are available

2768

What was the last computer book you purchased? Why?

2377

How will you enable or disable caching in the system level and table level?

895

What is ibm datastage?

973

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1061

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1040

How to Create a folder using pmrep command?

1180

I need a good brd and uc template?

1088

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