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 16866

what transformations are used for Variable port?

2 21093

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 17695

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

CTS,

1 9040

sas implimented companies in hyderabad

CTS, HSBC,

11 31871

IS SAS COMPILER OR INTERPRETER? EXPLAIN?

Aon Hewitt, HSBC, SCL, TCS,

3 21324

what is filelist concept in informatica

4 19827

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

TRE, Verinon Technology Solutions,

3 20675

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 6535

how to do scheduling in desktop intelligence in BO XI R2

3 15194

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

HCL, Merrill Lynch,

4 21872

what is prompt variable

HCL,

2 7968

what is textsource variable

HCL,

2 8090

what are diff b/w cognos and business objects

HCL,

6 11867

Un-Answered Questions { Data Warehouse }

What are the different types of variables in obiee 11g? Explain

974

What is a rollup component? Explain about it.

1198

how do u really know that paging to disk is happening while u are using a lookup transform?

2000

What are the ways to do a “table lookup” in sas?

1044

What are default access rights in teradata?

1144

How an expression transformation differs from aggregator transformation?

1050

Explain substr function?

1122

What are the job parameters?

1234

what is microstrategy narrowcast server?

1136

What is Indexing? how did u implement indexing?

2488

Which is faster fastload or multiload?

1133

What is the importance of the exception activity in datastage?

1082

why do u need the IOS upgradation in a FC switch

2293

How do I create and delete a cluster in aws redshift?

How to do unit testing in informatica? How to load data in informatica ?

1142

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