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 factless fact tables?

634


What are the different methods of loading dimension tables?

559


what are the different views that are considered when building an object-oriented software system?

621


What are components of reportnet?

595


What is normalization, first normal form, second normal form, third normal form?

532






What are the other names given to data warehousing?

640


What is the goal of optimizer?

585


What is ods (operation data source)?

551


How to know the time taken for particular report execution?

516


Suggest a good author for hyperion in data warehousing?

556


What is a cube in data warehousing concept?

662


Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

518


How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

541


Explain the hierarchies level data warehousing.

508


What are the different types of data warehousing?

514