How to pivot row data using informatica?
Explain which are the olap tools available that are supported by oracle?
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 metadata extension?
What is meant by metadata in context of a data warehouse and how it is important?
Explain the hierarchies level data warehousing.
Why is dimensional normalization not required?
Is union transormation is active transformation?
Tell me the Top 10 features of oracle that supports datawarehousing.
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Explain what does level of granularity of a fact table signify?
What according to you might be the future of data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?