You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Peoplesoft DataConversion

3 replies [Last post]
ashok_star2004's picture
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 02/13/2009
Posts: 45

Hi All,
We are implementing the DataConversion Process for ePerformance 8.9 to 9.0.Im new for this implementation. Now Im struck at an instance.We have data in a table T1 with 90 rows in 8.9 and 160 rows in 9.0.And the problem is that some rows with key fields are carrying different data in both the databases for the same key fields.
In 8.9:
key:a1
col1:120
col2:130

In 9.0
key:a1
col1:124
col2:130

Can anyone help me how to move this data to the upgraded database with out loss of data..

Thanks,
Ashok K.

rahulkhandelw's picture
User offline. Last seen 6 years 36 weeks ago. Offline
Joined: 10/16/2009
Posts: 34
Re: Peoplesoft DataConversion

Hi Ashok,

If your database is on oracle then give a try to this,

1. Disable the constraint on your table .
2. Run your script to load the data.
3. Enable the constraint with novalidate option.

I hope this must help you.

Please let me know whether it works for you or not.

Regards,
Rahul Khandelwal

Lepa's picture
User offline. Last seen 1 week 6 days ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Peoplesoft DataConversion

Quote:
If your database is on oracle then give a try to this,
1. Disable the constraint on your table .
2. Run your script to load the data.
3. Enable the constraint with novalidate option.

That is some trick rahul - Thanks for sharing this with us!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

ashok_star2004's picture
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 02/13/2009
Posts: 45
Re: Peoplesoft DataConversion

Hi Rahul,
Its great of you..It worked..Thanks a lot for your help Rahul..

Thanks,
Ashok K.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
4 + 16 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.