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

what is difference between folders and category ?

Tech Mahindra,

4 16872

what transformations are used for Variable port?

2 21099

what we require for D.modelling?

1 4966

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

CTS, Symphony,

6 17704

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

CTS,

1 9042

sas implimented companies in hyderabad

CTS, HSBC,

11 31879

IS SAS COMPILER OR INTERPRETER? EXPLAIN?

Aon Hewitt, HSBC, SCL, TCS,

3 21328

what is filelist concept in informatica

4 19829

What is LAG function?How is it used? can any one explain

TRE, Verinon Technology Solutions,

3 20678

we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....

IBM,

1 6542

how to do scheduling in desktop intelligence in BO XI R2

3 15197

how many types of variables in cognos report net and cognos 8

HCL, Merrill Lynch,

4 21886

what is prompt variable

HCL,

2 7972

what is textsource variable

HCL,

2 8097

what are diff b/w cognos and business objects

HCL,

6 11881

Un-Answered Questions { Data Warehouse }

What is surrogate key? Where we use it?

1011

What is a node in teradata?

1009

How many types of facts and what are they?

1031

Name the different type of processing based on the steps that you know about?

1077

What is the difference between drill through, drill across?

1100

What are the ETL Testing Operations?

1069

What are the various ways of incorporating security in microstrategy?

1026

What is a core dimension?

1086

What is repository manager?

1001

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1122

What are the uses of sas?

1291

Which versions are used in the bo dashboard work?

1069

What is "method/1"?

1081

When do we analyze the tables? How do we do it?

973

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1936

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