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 6740

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

CTS, IBM, TCS,

1 10088

what is a Galaxy Schema?

IBM,

2 9522

How many reports did you create in your project?

IBM,

3 6330

How many fact tables and dimension tables in your project?

IBM,

3 12641

What is a query set?

IBM,

3 9459

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 7662

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

CTS, IBM,

5 16972

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

HP,

4 7763

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

HP,

3 5977

What is Horizontal transformation, vertical transformation,diagonal transformation?

Cap Gemini,

2 9997

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 4393

what is size of u r database?

1 2377

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

Oracle,

2 6114

what is the size of ur database(like oracle)

HP,

2 6453

Un-Answered Questions { Data Warehouse }

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415

What is the purpose of Dataware Control?

1110

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

1189

Have you have ever worked in unix environment and why it is useful in datastage?

1210

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

2088

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

2054

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

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

6057

what are the names of the reports that you prepared?

1185

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

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

2480

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

3648

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)

2790

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

2324

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