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 6663

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

CTS, IBM, TCS,

1 10016

what is a Galaxy Schema?

IBM,

2 9398

How many reports did you create in your project?

IBM,

3 6227

How many fact tables and dimension tables in your project?

IBM,

3 12503

What is a query set?

IBM,

3 9291

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 7555

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

CTS, IBM,

5 16788

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

HP,

4 7564

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

HP,

3 5853

What is Horizontal transformation, vertical transformation,diagonal transformation?

Cap Gemini,

2 9872

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 4306

what is size of u r database?

2321

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

Oracle,

2 5982

what is the size of ur database(like oracle)

HP,

2 6327

Un-Answered Questions { Data Warehouse }

what is sas business intelligence? : Sas-bi

1195

How might one distinguish in the case of mapping is right or not without associating session?

1139

what are the special features in cognos reportnet?

1077

What are the difference between sas functions and procedures?

1167

What do you mean by tpt in teradata?

1030

Briefly explain the aggregator transformation?

1024

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

2083

When we use aggregate awareness function in designer?

989

Do you view contain data?

952

What are the various file formats involved in reportnet?

999

how do you debug and test your sas programs? : Sas programming

1139

What are the co> operating system’s assorted library of integrated components?

1130

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2373

Suppose we do not group by on any ports of the aggregator what will be the output?

1053

What are algorithms provided by Microsoft in SQL Server?

2066

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