What are data modeling and data mining? Where it will be used?
Explain what are the basic needs to join two sources in a source qualifier?
Explain reference cursor?
What is aggregate fact table?
What is the difference between olap and datawarehosue?
What is Active Datawarehousing?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
I have two universes created by two difference database can we join them in designer & report level? How
What is data warehosuing hierarchy?
Explain what are the possible data marts in retail sales?
Why facts table is useful in representing the data?
what are the major three types of modeling used?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What are the types of SCD?
What do you mean by static and local variable?
