Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are the data types present in bo? What happens if we implement view in the designer n report?
What are the data types present in bo?
What is meant by metadata in context of a data warehouse and how it is important?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
what is difference between drill & scope of analysis?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is the difference between olap and oltp?
Can you pass sql queries in filter transformation?
What is meant by metadata in context of a data warehouse?
What is a data profile?
Can a dimension table contain numeric values?
What do you mean by static and local variable?
Can any one explain the hierarchies level data warehousing.
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.