cancel
Showing results for 
Search instead for 
Did you mean: 

ETL Job (Perl and SQL Scripts)

Former Member
0 Kudos
98

Hi,

We have a requirement as follows :-

Data is extracted from legacy system & inserted/updated to Warehouse system using "ETL Job (Perl and SQL Scripts)".

This is a scheduled job everyday.

Could the experts please let me know if this interface is file based. If not then can we get any idea about the way it transfers the data based on above statement.

Thanks,

Best regards,

Prashant

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi

For your reruirement just go through the DBMS_SCHEDULER buil in package in oracle pl/sql

in that u can get the run the job everyday.

Thanks

Bharathi.ch