DB Administration interview questions – page 18

How does replication takes place between two sites?

Can u copy the session to a different folder or repository?

What are the steps to build the data warehouse?

What kinds of data belong in a data warehouse?

Explain in brief about critical column.

Is it correct/feasible develop a Data Mart using an ODS?

What are the types of External Loader available with Informatica?

Explain about Recovering sessions?

If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

What is the difference between OLAP and Data Mining?

What is ODS?

What are non-additive facts in detail?

What is listner how u can change default name & port

What is backward compatibility in abinitio

Why would I want to access the data warehouse when I have a mainframe computing system?

What are dimensions?

What is ? Extended Star Schema? and how did it emerge?

What is data cleaning? How can we do that?

What is the difference between DATABASE ADMINISTRATION & ORACLE?

My transaction take 30 min i want if my transaction data written in table after each 5 min . If transaction commit or rollback then do according work . this is done through pl/sql how?

What does level of Granularity of a fact table signify?

Which is the optimized method of extracting the data?

What is the function you would use to transfer a string into a decimal?

What do you mean by cubes?

What is the main advantage of impromptu over cognos reportnet?

What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

What is active data warehousing?

Why are we not use tablespce begin backup with read only tablespace?

What's metadata? What's a data dictionary?

What is a level of Granularity of a fact table?