| Author |
Message |
Raa_ONE
Participant
Joined: 14 Sep 2018
Posts: 5
Points: 33
|
|
| DataStage® Release: 11x |
| Job Type: Parallel |
| OS: Windows |
| Additional info: Both windows and unix OS |
|
How do you optimize the process when your data after performing multiple operations taking a long time to load to target systems.
|
|
|
|
|
|
ray.wurlod
Participant
Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 54407
Location: Sydney, Australia
Points: 295092
|
|
|
|
|
|
|
How are you loading to target? INSERT, Insert/Update, or bulk load?
|
_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
|
|
|
|
|
Raa_ONE
Participant
Joined: 14 Sep 2018
Posts: 5
Points: 33
|
|
|
|
|
|
|
Consider I'm doing insert and bulk load on two different occasions.
|
|
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 42790
Location: Denver, CO
Points: 220550
|
|
|
|
|
|
Consider that you've been asking
extremely
general / hypothetical questions and what we're really all about here is peer-to-peer support of specific issues / problems. I'm not sure how you can expect anything but extremely general answers in return...
|
_________________
-craig
"I don't mind you comin' here and wastin' all my time time"
|
|
|
|
|
qt_ky
Group memberships:
Premium Members
Joined: 03 Aug 2011
Posts: 2822
Location: USA
Points: 21387
|
|
|
|
|
|
I think I know the answer...
You look in DataStage Director and click on the Elapsed Time column header to sort and help you find the longest running jobs. Then you can know which ones need performance tuning.
|
_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
|
|
|
|
|
|
|
