what are different ways of loading data to data warehouse
using oracle?
what are the all possible features supported modify stage?
How can we schedule the graph in unix?
I have two universes created by two difference database can we join them in designer & report level? How
What is defined as partial backup?
What is a staging area? Do we need it? What is the purpose of a staging area?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain when do we analyze the tables? How do we do it?
What are data validation strategies for data mart validation after loading process?
What is critical column?
What is application.cfm?
Explain how to get the first 100 rows from the flat file into the target?
Explain if a flat file cotains 1000 records how can I get first and last records only?