To transfer tables from People soft(not sure) database to
Moderators: chulett, rschirm, roy
To transfer tables from People soft(not sure) database to
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.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Last edited by ray.wurlod on Mon Oct 02, 2006 8:56 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
