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?

1 2115

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

1 2115

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 4330

what is dynamic insert?

1 2269

what is pmrep command?

1 2500

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

1 2012

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

1 3545

Eliminating of duplicate records without using dynamic lookups

IBM,

4 15757

what are Lookup caches options? Including persistent caches.

1 2050

Difference between flat files and relational sources?

Satyam,

1 2306

what is session partitioning?

1 4562

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

CTS,

2 7387

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

2 6165

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

1 2028

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

1 2020

Un-Answered Questions { Data Warehouse }

What is a rollup component? Explain about it.

1243

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2493

what are the data modeling tools you have used?(polaris)

2058

explain in detail about type 3?

1084

How would you format some text using css to be verdana and bold?

1150

draw informatica architecture 8.6 ?

3947

Explain about a tricky situation for which you found a very simple solution?

1077

What is the difference between business requirement document and use case document.

1082

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

What sort of existing documents should business analysts refer to when starting on a new project?

1078

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2264

What is dimensional table?

1164

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

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