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

data stores in which location while using data set stage as the target?

IBM, TCS,

1 7419

How to Join Tables my Source is having 15 table target is one?

TCS,

4 8131

what is snow flack schema?

2 6425

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

TCS,

2 7747

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17711

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 4189

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

Cognizant,

2 8438

how did u understand business requirement?

TCS,

2 5861

what is hybrid schema

TCS,

4 16666

What is the difference b/w the simple Universe and Complex Universe?

2 7436

Aliases and Contexts Which once will give the better performence when resolve the loops?

HCL,

3 8894

What is meant by multiple data provider.How to use it in universe as well as reporting environment?

TCS,

6 11902

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 3931

What is meant by data federator and what is the use of it?

TCS,

2 7756

What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

TCS,

1 3685

Un-Answered Questions { Data Warehouse }

Compare and contrast aggregates & indexes

3787

How are numeric and character missing values represented internally?

1673

What are the data marts?

988

What are cluster analysis in data warehousing?

1128

what is the difference between nodup and nodupkey options? : Sas programming

1210

What is the difference between informatics 7x and 8x and what is latest version?

1098

What is transformation?

1111

What are the new features of Power Center 5.0?

1804

What are the various types of transformation?

1197

How to limit decimal places for variable using proc means?

1122

Mention what is SAS data set?

1147

Can we create a Integration service without a Repository service and vice versa?

1227

Difference between project merge and object manager?

1033

Explain the situation where you have applied SCD in your project?

2059

What is is a data flow graph?

1134

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