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 20692

How Metrics Studio is better than Report Studio?

2605

Is it possible to see the data in dataset?

iGate,

3 8221

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 9258

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

Cognizant,

4 13717

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 6479

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 7228

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

CTS,

3 8058

List the transformation in informatica.

TCS,

1 12315

static prompt in microstrategy.

iGate,

2 9852

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

1 5077

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

HCL,

1 5500

what are the tabs in cognos ?

2 5476

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

1 5091

Un-Answered Questions { Data Warehouse }

What are various types of gateways in cognos?

1063

Compare microstrategy and tableau.

988

What is partitioning? Explain about round-robin, hash partitioning.

968

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2040

Explain what are slowly changing dimensions?

1026

What is surrogate key? Explain with examples.

1158

what are different storage options supported by oracle ?

2092

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

4082

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2038

SCD2 will work on only dimension tables as well as fact Table?

1401

Is it possible to get a floating window in microstartegy web? If yes, how?

1162

What is the basic syntax for teradata select statement?

1049

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2322

How do you update the records with or without using update strategy?

1118

What can we do with datastage director?

1239

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