What is a ETL/ How does Oracle support the ETL process?
ETL stands for Extract transform and load.
In general the entire ETL process is only SQL scripts
executed against the database. Oracle being a Database
which favours ETL through SQL scripts.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the versions of reportnet?
What is the main difference between star and snowflake star schema? Which one is better and why?
What is execution plan?
What is the definition of cube in datawarehousing?
what is Materialized Views?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is the limit to the number of sources and targets you can have in a mapping?
What is the difference between olap and oltp?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the various methods of getting incremental records or delta records from the source systems?
How to define a cube??
What are the tools available for etl?