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


Please Help Members By Posting Answers For Below Questions

What is vldb(very large databases)?

546


What are cluster analysis in data warehousing?

564


In a star schema, are foreign key constraints between facts and dimensions neccessary?

544


What is recovering sessions?

545


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

484






What are the different methods of loading dimension tables?

561


What is loop in data warehousing?

682


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

558


Explain why should you put your data warehouse on a different system than your oltp system?

514


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.

644


What is the metadata extension?

542


What is meta data and system catalog?

1855


How to create prompts in report net?

557


How much data hold in one universe.

553


What are the data marts?

525