What is a ETL/ How does Oracle support the ETL process?
Answer Posted / pradeeshkumar
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 |
Post New Answer View All Answers
What is the difference between junk dimension and degenerated dimension?
Explain how to generate iqd file from framework manager?
Explain what are the mapping paramaters and maping variables?
Can decision tree be implemented using SQL?
Which component has onread method and what it is used for?
Where do we use semi and non additive facts?
How to define a cube??
Explain what is the data type of the surrogate key?
What is type 2 version dimension?
What is data warehosuing hierarchy?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is freehand sql?
What is data analysis?
What is a general purpose scheduling tool?
Explain what is the difference between power center & power mart?