DB Administration interview questions – page 16

Why is SAS so popular?

What are the advantages data mining over traditional approaches?

What is the main difference between Inmon and Kimball philosophies of data warehousing?

What are variables?

How do u clean the datastage repository.

What is XMLA?

How to Create Surrogate Key using Ab Initio?

What are fact tables?

How can we write parallel routines in data stage PX, can anyone help out in this one quickly. If is any example programe its very helpful to me

I have different sources in different databases these sources may be have 100 tables. I want to load these tables into a single target.How can we perform this task ?

What is difference between stored procedure transformation and external procedure transformation?

How to run the job in command prompt in unix?

How do you connect two fact tables ? Is it possible ?

What is DATA integration?

What is Data Warehousing?

Can a dimension table contains numeric values?

How to create repository in abinitio for stand alone system(LOCAL NT)?

What is difference between file and table in abinitio

I have active redo log is it possible increase size and how?

If a user complaint his query run slow how u detre mine which is reason ?

What is the difference between Datawarehousing and Business Intelligence?

What is Data warehousing Hierarchy?

What are external procedures ? Why and when they are used?

I want to write data from table to flat file this is possible through pl/sql how ?

What is real time data-warehousing?

What is a data mart?

What is the difference between view and materialized view?

If i create unquie index on empid of employees table which index i create bitmap orbtree why ?

What is the difference between oracle 9i and 10g database?

Is it same we set log_archive _start =true or alter system archive log startif u use any one then automatic archive ing start or not ?