what are the others of "bad files" and "discard files" when using sql*loader?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is data analysis?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is data mart in data warehouse?
What is core dimension?
How to handle multi value dimensions?
What a static and local variable?
What are the different types of datawarehosuing?
What is crass reference table?
what are different storage options supported by oracle ?
What are aggregate transformation?
Explain the difference between data ware house & data mart?
Explain datawarehousing?
I have two universes created by two difference database can we join them in designer & report level? How