Page 1 of 1
To transfer tables from People soft(not sure) database to
Posted: Sat Sep 30, 2006 11:09 am
by siquadri
To transfer tables from people soft(not sure)database to oracle datawarehouse .I have to create a job and i am new to this.Can any one give me idea of various stages to use.
Posted: Sat Sep 30, 2006 3:53 pm
by ray.wurlod
Welcome aboard. :D
Does your site have the PeopleSoft PACK, which includes table definitions and canned jobs for extraction from PeopleSoft databases? If so, then to extract the data ought to be straightforward. Your business analysts should have provided you with source-to-target (or, better, target-from-source) mapping documents. Using these you can design and implement the T and L parts of ETL into a target of your own (enterprise's) design.
Posted: Mon Oct 02, 2006 8:38 pm
by kumar_s
If you are provided with the access, you should be able to read via your OCI stage as well.