Hi All,
I am fresh to DataStage, I'm working on a protocol on moving the datas from peoplsoft CRM transaction system to peoplesoft EPM system. DataStage is delivered with EPM and jobs are also delivered
Anyone with such experience could help me out.
Thanks,
Vindy
Loading Datas from CRM system to EPM System
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Sep 16, 2004 5:26 am
- Location: India
Hi,
Which version of EPM are u talking about..
For Peoplesoft EMP 8.9
If u see there are categories in the Datastage project go to CRM datamart folder,if i remember correctly there are some staging jobs for CRM in Hundreds,first u have to run those jobs after that data get loaded in the source table of Dimensions job,and some common staging jobs which loads data to shared jobs,but be careful to run everything in proper order ,
Best option is to ask for support from Peoplesoft EPM team..
Regards,
Devesh
Which version of EPM are u talking about..
For Peoplesoft EMP 8.9
If u see there are categories in the Datastage project go to CRM datamart folder,if i remember correctly there are some staging jobs for CRM in Hundreds,first u have to run those jobs after that data get loaded in the source table of Dimensions job,and some common staging jobs which loads data to shared jobs,but be careful to run everything in proper order ,
Best option is to ask for support from Peoplesoft EPM team..
Regards,
Devesh
EPM 8.9 Version
Hi Devesh,
I have installed the datastage. i have also imported the jobs
(delivered *.dsx files).
Now want to know how to run those jobs in order.
I mean whether we have to manually excute each job individually
or there are some means to run it as per the sequence.
Regards,
Vindy
I have installed the datastage. i have also imported the jobs
(delivered *.dsx files).
Now want to know how to run those jobs in order.
I mean whether we have to manually excute each job individually
or there are some means to run it as per the sequence.
Regards,
Vindy
DEVESHASTHANA wrote:Hi,
Which version of EPM are u talking about..
For Peoplesoft EMP 8.9
If u see there are categories in the Datastage project go to CRM datamart folder,if i remember correctly there are some staging jobs for CRM in Hundreds,first u have to run those jobs after that data get loaded in the source table of Dimensions job,and some common staging jobs which loads data to shared jobs,but be careful to run everything in proper order ,
Best option is to ask for support from Peoplesoft EPM team..
Regards,
Devesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
projects in DataSage
Hi Vindy,
In your EPM 8.9 project, are you implimenting any other warehouses other than CRM Warehouse? If so, are you having all the dsx files in one project or do you have multiple projects, one for each module like one DataStage project for CRM, one for HR and one for Common dsx jobs??
Thanks,
In your EPM 8.9 project, are you implimenting any other warehouses other than CRM Warehouse? If so, are you having all the dsx files in one project or do you have multiple projects, one for each module like one DataStage project for CRM, one for HR and one for Common dsx jobs??
Thanks,