Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6261

Difference between DSS & OLTP?

IBM,

6 37727

Explain grouped cross tab?

1542




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14350

How many repositories can we create in Informatica?

Informatica,

14 17122

What is surrogate key?

IBM,

5 16362

What is difference between Mapplet and reusable transformation?

UST,

3 3109

What is aggregate awareness?

2 4918




Explain reference cursor?

1084

What are parallel querys and query hints?

1178

DWH architecture?

6 12551

What are cursors?

4 5024

Advantages of de normalized data?

2 8586

What is operational data source (ODS)?

2 7267

What is meta data and system catalog?

1162


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

what are the others of "bad files" and "discard files" when using sql*loader?

1002


what are the all possible features supported modify stage?

967


what is parallel query?

965


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1275


if you use oracle sql*loader , how do you transform data with it during loading?

950






in general which algorithms for used?

883


What are parallel querys and query hints?

1178


What are the different problems that ?Data mining? can solve?

1662


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

984


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

956


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1136


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

19


Compare and contrast aggregates & indexes

2621


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

881


How do you setup Lo-cockpit?

1996