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?

QualTech,

1 3370

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

1 2221

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 1959

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 2101

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

1 2054

how do u set partition points in the mapping?

1 2678

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

1 2345

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 2017

what is meant by drill through?(Mascot)

1 3005

what are the different Reporting and ETL tools available in the market?

3 12238

explain the methodology of Data Warehousing?(Polaries)

1 2391

what are the concerns of OLTP and DSS systems?

1 2012

what is the difference between OLTP database and data warehousing database?

4 7717

what is data modeling?

1 1968

what is the difference steps for data modeling?

1 2229

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

What is node? How many nodes and amps used in your previous project?

1173

Write the unconnected lookup syntax and how to return more than one column.

1174

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

2264

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

1670

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

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

2057

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2313

Demonstrate experience in maintaining quality process standards?

2672

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

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!!!

2260

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

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

1938

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