external sort stage is the sort stage.ray.wurlod wrote:Can you be more specific about what you mean by these terms? For example there's no such thing as an "external sort stage". ...
Search found 36 matches
- Thu Jul 15, 2010 12:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between external sort and inline sort
- Replies: 7
- Views: 12063
- Wed Jul 14, 2010 10:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How does a join stage work?
- Replies: 2
- Views: 7951
How does a join stage work?
Hi
Could any one explain me how does a join stage work from conceptual perspective?
If i have some 10 million recs on each i/p how/where does the join stores that data in order to compare/find a match/How it make use of memory and buffer etc?
Please let know if you need more details...
Could any one explain me how does a join stage work from conceptual perspective?
If i have some 10 million recs on each i/p how/where does the join stores that data in order to compare/find a match/How it make use of memory and buffer etc?
Please let know if you need more details...
- Wed Jul 14, 2010 10:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between external sort and inline sort
- Replies: 7
- Views: 12063
Difference between external sort and inline sort
Hi, Could any one explain me the the difference between external sort and inline sort apart from external sort stage has more options? I am trying to understand how they differ in terms of creation of OSH,usage of scratch disk and performance impact (If there are any more please mention them as well).
- Tue Nov 17, 2009 11:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: USER IDS are revoked while running a sequence job
- Replies: 4
- Views: 2715
Please strive to use a professional standard of written English on DSXchange. It helps those whose first language is not English. Mine is, but I still struggled with what you had written. There is no message limit of 72 or 144 characters here; you can be as expressive as you wish. So SMS-style abbr...
- Tue Nov 17, 2009 6:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: USER IDS are revoked while running a sequence job
- Replies: 4
- Views: 2715
- Tue Nov 17, 2009 3:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: USER IDS are revoked while running a sequence job
- Replies: 4
- Views: 2715
USER IDS are revoked while running a sequence job
Hi All, We have a sequence job which has 22 parallel jobs all are being run parallely.Each parallel job would simply extract the data and load it into target table.In this way we are loading all the 22 tables in dev and test environment successfully. But,when we tried to run the same job after deplo...
- Wed Nov 04, 2009 8:49 am
- Forum: General
- Topic: Problem in sending Email
- Replies: 8
- Views: 7146
- Wed Nov 04, 2009 8:15 am
- Forum: General
- Topic: Problem in sending Email
- Replies: 8
- Views: 7146
Problem in sending Email
Hi Friends we are using Email Notification Activity in Job Sequence. after completing the sequence run we are not getting any mail, in log files we are getting message like below: Sent message to 'someone@abc.com' Executed command: /opt/datastage/Ascential/DataStage/Projects/greyhound_jde_new/sendma...
- Wed Nov 04, 2009 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Email Notification Activity problem
- Replies: 6
- Views: 5855
- Thu Oct 22, 2009 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute Command Activity in Sequence Job -- return value
- Replies: 8
- Views: 12887
- Wed Oct 21, 2009 10:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute Command Activity in Sequence Job -- return value
- Replies: 8
- Views: 12887
Hi all, Thanx a lot for your Prompt reply.My Execute acivity is working fine when I have made a small change to my script. But,I need some help in sending the exact error in mail (using Notification activity). As of now In the mail I am getting the status of the Job but not the error(present in the ...
- Mon Oct 19, 2009 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute Command Activity in Sequence Job -- return value
- Replies: 8
- Views: 12887
Execute Command Activity in Sequence Job -- return value
Hi All, I am using an script to delete all the records in all the tables before I load them using my sequence job.So,i have used Execute Command Activity in Sequence Job first. My requirement is i need to capture the status of my script.If it was not executed properly which means it could not delete...
- Thu Oct 15, 2009 12:05 am
- Forum: General
- Topic: TO delete data from tables before execution of sequence job
- Replies: 1
- Views: 1865
TO delete data from tables before execution of sequence job
Sequence job performs the table loads.These tables have a parent child relationship.First the Parent table is loaded and then after a sequence the child table will be loaded. My requirement is to delete data from all the tables before I start the sequence job.Here we need to delete data from the chi...
- Wed Oct 07, 2009 10:26 pm
- Forum: General
- Topic: Email Notification of Status of Job run
- Replies: 0
- Views: 1232
Email Notification of Status of Job run
Hi All, I have around 20 Parallel jobs.My requirement is I need to send a mail which should contain the status of job.i.e,if job is success it should be just Success else if the Job was failed then the status has to be Job was failed along with the Reason for the failue. Do I need to use the email n...
- Tue Oct 06, 2009 11:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using $PROFDEF as default value in Parameter Set
- Replies: 11
- Views: 5753