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 are session timeout and application timeout? Where we have to do this process?
Explain datawarehousing?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are data modeling and data mining?
Explain a linked cube?
What is the definition of cube in datawarehousing?
What is VLDB?
What is the function of surrogate key in data warehousing?
Explain what are the methodologies of data warehousing?
Where the cache files stored?
What is drill-through?
Explain the difference between filter and conditin?
What is the difference between metadata and data dictionary?