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

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6756

What is a scope? can you tell me one example for scope?

CTS, IBM, TCS,

1 10098

what is a Galaxy Schema?

IBM,

2 9535

How many reports did you create in your project?

IBM,

3 6347

How many fact tables and dimension tables in your project?

IBM,

3 12652

What is a query set?

IBM,

3 9477

If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

IBM, Polaris,

2 7678

write the sql query to display 5th and 10th row in a table?

CTS, IBM,

5 16989

I have source like this 1:2;3. so i want to load the target as 123

HP,

4 7779

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

HP,

3 5981

What is Horizontal transformation, vertical transformation,diagonal transformation?

Cap Gemini,

2 10002

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

TCS,

1 4401

what is size of u r database?

1 2390

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

Oracle,

2 6130

what is the size of ur database(like oracle)

HP,

2 6478

Un-Answered Questions { Data Warehouse }

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

2104

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

2261

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

2057

What is dimensional table?

1159

What r the names of the reports that you prepared?

1028

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

1196

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2173

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1172

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

1077

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

2491

Explain how to generate iqd file from framework manager?

1020

faq's on cognos

4112

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

1994

what are the dimensions that you have in your current project?list them?

2090

explain in detail about type 3?

1082

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