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

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 4390

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

1 4094

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 4819

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1 2957

how do u really know that paging to disk is happening while u are using a lookup transform?

1 2506

how do u set partition points in the mapping?

Quintiles,

1 2321

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 3845

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1 2103

what is meant by drill through?(Mascot)

1 4433

what is pmrep command?

1 2502

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

2 5219

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

DELL,

1 5629

Eliminating of duplicate records without using dynamic lookups

1 4452

what are Lookup caches options? Including persistent caches.

1 4825

Difference between flat files and relational sources?

1 2384

Un-Answered Questions { Data Warehouse }

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

Hi, If anyone has base SAS certification dumps, please share.

1937

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

What is dimensional table?

1162

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2060

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

1081

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

1147

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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

1077

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

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

2436

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

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