What is static and local variable?
Where we use surrogate key explain with example?
How to generate the cubes in framework manager?
Explain what is a cube in data warehousing concept?
Is there any rownum object from which we can do this?
What is the difference between power center and power mart?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is the difference between agglomerative and divisive hierarchical clustering?
Explain ddl (data definition language)?
What are session timeout and application timeout? Where we have to do this process?
What is DTS ?
How are models actually derived?
What is difference between e-r modeling and dimensional modeling?