DSXchange

Hello there, I designed a job which has about 20 stages in it. From the performance stand-point, would it be a good idea to design a job with so many stages especially when I can break this job into small jobs. Thanks in advance. -Yamini Depends...... Assuming you have enough CPU, and all your inte...

Aswini wrote:thanks a lot for the welcome.
I am not able to get anything, this is the info i got after resetting the job, please let me know if there is a palce i should look for.......right now this is the error log, please review the attachment.

Which job is it?

thanks for your reply Peter...unfortunately that wasnt our problem. I changed that setting in the DSN properties, made sure I was entering the right password, but the problem is still there

We are acessing a DB2 database on a AS/400 box using the client access ODBC driver. We were able to setup the connectivity and continue development, but all of a sudden Datastage was not able to connect to that dtabase anymore. The jobs would simply hang when trying to connect to it. I was however a...

thats cool... let me restate so that i can confirm if I am understanding it right.. 1) so if I have this in the sequence Routine-->Job 2) I put the trigger in the routine as otherwise 3) enable the "automatically handle the activities that fail.." in the sequence. Then the sequence would ...

Try a self join....3 times...

thanks for the information guys..... I hoping it was publicly available

Hi,

Has anyone heard about a Job migration tool called DSMigrate ? I want some information about this tool.

Quite easy if u were on Unix...Just use named pipes to do your job.......Write into the pipe using DS. Read from that pipe using another application.. write back to another pipe from the application...Read from DS.... I dont think it is possible to implement a similar application under windows. Wind...

you can do it using a SQL stmt. You will need a two-part key to accomplish it. Assuminng your data is of the type: col1 col2 data 1 1 "ABC" 1 2 "BCD" You can compress it into one row using a self join. select a.col1, a.data, b.data from tablename a Left outer join tablename b ON ...

There is a bug in DS windows that causes it to crash if you are using lots of hash file stages at the same time. Can you please elaborate, ideally providing a reference to the support case number? Or is it just that you didn't set the T30FILE tunable large enough? the support case number is 385112*...

There is a bug in DS windows that causes it to crash if you are using lots of hash file stages at the same time. Can you please elaborate, ideally providing a reference to the support case number? Or is it just that you didn't set the T30FILE tunable large enough? Umm no...This is a known issue wit...

I've had the same problem this morning. It might be because your are using the "reset if required" option. I had inadvertedly used it in my sequence and ran into the same issue. Try taking it out. It seemed to have solved mine, but im not a 100% sure, my jobs are still running. Also are yo...

Use the aggregator stage. Pretty easy to use. Hi All ... I've been trying to fit this requirement into a hash file without success. I know I can solve this with a temporary table, but I'd rather do a hash: I will create a series of rows out of my Transform. These rows will contain a column named sma...

Datastage provides a "command stage" which lets you invoke an OS command. Issue the sendmail command when your criteria is met.

I dont recall exactly how you invoke sendmail, but im pretty sure you can figure it out yourself