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 7411

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

TCS,

4 8118

what is snow flack schema?

2 6416

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 7732

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17691

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 4180

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 8432

how did u understand business requirement?

TCS,

2 5855

what is hybrid schema

TCS,

4 16659

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

2 7431

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

HCL,

3 8880

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

TCS,

6 11879

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

1 3920

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

TCS,

2 7743

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 3680

Un-Answered Questions { Data Warehouse }

What is meant by a Parsing Engine?

1198

Explain microstrategy logical primary keys?

1005

What is factless fact tables?

1218

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2134

Explain the term 'row' related to relational database management system?

965

what are the deliverables?in your project?

2158

Distinguish between cognos dynamic cube and transformer/tm1 cube and powerplay cube?

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

985

Explain lookup transformation in informatica

1083

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2108

can metadata be manually edited? If yes, how?

1042

What is MAX CORE of a component?

1328

What is meant by metadata in context of a data warehouse and how it is important?

1212

How do you convert single row from source into three rows into target?

1172

what the mean of version error in crystal?

2404

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