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 are the session parameters? How do u set them?

2052

how do use session mapping parameters ?(in which transformation)

2021

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 4233

what is dynamic insert?

2210

what is pmrep command?

2440

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

1953

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

1 3445

Eliminating of duplicate records without using dynamic lookups

IBM,

4 15532

what are Lookup caches options? Including persistent caches.

1978

Difference between flat files and relational sources?

Satyam,

2246

what is session partitioning?

1 4470

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

CTS,

2 7250

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

2 6032

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

1970

how would u estimate the size of Aggregator transform data and index cache?

1965

Un-Answered Questions { Data Warehouse }

What are the methods by which it non-durable model could be changed into the durable model?

964

What is called data cleaning?

1245

What is brodcasting and replicate?

1215

What are the types of containers in datastage?

1193

What is joiner transformation in informatica?

1049

how would u estimate the size of Lookup transform data and index cache?

2137

where you can save the report net documentation in our local system?

1050

What are the difficulties u faced while doing vital signs table or dataset?

2398

Can you explain players in datastage?

1204

How create measures and dimensions?

1084

Describe an informatica powercenter?

1131

What are target types on the server?

998

What is staging area referring to?

1134

What is the importance of having monitor service in cognos?

1038

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2276

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