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 Regular Dimension and Measure Dimensions and Diff b/w them ?

2 20695

How Metrics Studio is better than Report Studio?

2611

Is it possible to see the data in dataset?

iGate,

3 8223

what are the advantages of dataset compare to fileset?

iGate,

1 7807

what are the nulls on microstrategy report and how to mask them.

iGate, TCS,

1 9262

what is the difference between the .dbc and .cfg extensions and give any clear information ?

Cognizant,

4 13723

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 6481

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 7232

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

CTS,

3 8065

List the transformation in informatica.

TCS,

1 12321

static prompt in microstrategy.

iGate,

2 9854

where does the default group roew in a router is stored what is the default size of memory in router

1 5080

How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

HCL,

1 5504

what are the tabs in cognos ?

2 5478

What are exact SAS Base contents..?N what r SAS Tools..?

1 5093

Un-Answered Questions { Data Warehouse }

Difference between data warehousing and olap?

1097

What is substr in informatica?

1213

What are the advantages of informatica?

1014

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1158

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1749

What are the various kinds of containers available in datastage?

1048

What can we do to improve the performance of informatica aggregator transformation?

1098

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1079

What is a dimension?

1037

What is data analytics in simple terms?

1200

Nls stands for what in datastage?

1193

What is mapplet in informatica?

1065

Define joiner transformation?

1056

What’s the use AWS redshift cluster Service?

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1801

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