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 vldb(very large databases)?
What are cluster analysis in data warehousing?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is recovering sessions?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are the different methods of loading dimension tables?
What is loop in data warehousing?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain why should you put your data warehouse on a different system than your oltp system?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is the metadata extension?
What is meta data and system catalog?
How to create prompts in report net?
How much data hold in one universe.
What are the data marts?