Hierarchy of DWH?
Answers were Sorted based on User's Feedback
Answer / 9885657928
1.Source
2.Exteact
3.Tranform
4.Load
5.Taget
| Is This Answer Correct ? | 21 Yes | 3 No |
What is conformed fact?
How to eliminate duplicate rows from flat file?
what is table partitioning? How it is useful to warehouse database?
what is Materialized Views?
What is the difference between static cache and dynamic cache?
What is difference between a connected look up and unconnected look up?
What is an OLTP (Online Transaction Processing) System?
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?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is the difference between snowflake and star schema?
Explain what are the advantages of query studio compared to report studio?
Explain when do we analyze the tables? How do we do it?