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

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 5512

Parameter and variable differences

1 2134

Reusable transformation and shortcut differences

1 1898

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 2650

Implementation methodology

1 1797

Do you have knowledge in ralph kimball methodology

1 3664

According to his methodology what all you need before you build a datawarehouse

1 1827

How do you recover rows from a failed session

1 3121

Sequence generator, when you move from develoment to production how will you reset

1 2169

Whats there in global repository

1 1771

Repository user profiles

1 1839

How do you set a varible in incremental aggregation

1 1973

Can you create a flatfile target

ABC,

3 4318

What did you do in source pre load stored procedure

1 2567

Scheduling properties,whats the default (sequential)

1 2034

Un-Answered Questions { Data Warehouse }

What is dimensional table?

1168

faq's on cognos

4114

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

1082

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

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

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

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

1150

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1104

Hi friends, what are the new features in abinito3.0?

2860

What is a rollup component? Explain about it.

1246

draw informatica architecture 8.6 ?

3949

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

1175

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2796

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

Write the unconnected lookup syntax?

1153

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