DSXchange

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". ...

external sort stage is the sort stage.

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...

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).

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...

Hi Andrw,

Thx for u r reply.I got rid of above issue.The Issue arised bcz in env parameters my pwd is not encrypted but in all my individual jobs it is encrypted.

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...

Same Parameters (server,sender and receiver names) are used in Production job and it is running fine (We are receiving the mail).But not sure why it is giving problem here

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...

Hi Ramu,

Is your issue resolved?If yes,could you plz let me know the resolution.I am also facing the same issue.

chulett wrote:Did you try enabling the 'Include job status in email' option? That should pull that error from the log into the email body. ...

I am getting only the status in the mail when this option was enabled..........not the error.......

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 ...

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...

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...

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...

Hi Nicole,

My Issue was resolved after Installing the Fixpack(Patch).So,Installing the same would resolve your Issue also.