DSXchange

It's always better not to use interactive processes when you test something using scripts in datastage. There might not be a problem at all with your script. I am not a pro at psexec (Just downloaded, and checked it). A few observations: 1) Is your D:\Lab\TestPsExec2.bat on the remote server? 2) Ins...

Yes.

You should use Datasets for better performance.

Yes there is. But, you need to answer Roy's question for that.

If I were you, I would definitely dump data into flat files, and then do the joining in a different job. One of the reasons as Ray pointed out is that you don't have to extract the whole data again, if something goes wrong. The second is that: you can make the extraction job run on more nodes compar...

Dump the 'before' and 'after' data into two sequential files. Use a Hex-editor to compare the values of these, There has to be something different. Sometimes, things look the same to the naked eye but are not.

To the best of my knowledge, there is no certification of Datastage server edition (and I doubt to see any in the future). There are three certifications in the "datastage family" first is the DataStage Enterprise Edition certification for v7.5, one for Qualitystage, and one for Informatio...

There are only two editions of Datastage Enterprise Edition which let you to run the jobs on a Windows server (officially Windows 2003 Server). They are Datastage Enterprise Edition 7.5x2 (not to be confused with 7.5.2) and Datastage Enterprise Edition 8.x

To achieve this, you will have to store the "date" and the "sequence" number somewhere, so, that it can be retrieved in the next run. > Get the date and sequence number at the start of the sequence. > Compare the date previously fetched with the current date, If they are the same...

I feel on Cloud number nine, Not because I created something great. But, because people find it useful. Thank you very much for all your comments. Please feel free to give feedback on this, I'll try to make the changes you guys want to see.

Once again Thanks for all the encouraging comments.

Hi all, I am planning to take up Datastage certification this month. I have been through a lot of useful stuff on the web. I am planning to document the preparation I do, and my experiences on my blog (<a href = "http://minhajuddin.blogspot.com" >http://minhajuddin.blogspot.com</a>). Pleas...

Do you want records which don't have a match in the join in the rejected records? If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the...

Does the requirement ask you to *use* a join stage?

State your requirement clearly, that would help others help you :D

Nudge it to the top, if you find this useful, so others too can use this :D

Use the surrogate key generator stage to generate your keys or use the system variables which give you the Partition number and the number of partitions to get keys which are not duplicates.

Hi all,

I have been using a utility which I created in dot Net to view delimited files in an organised way. Here is the link to it

http://minhajuddin.blogspot.com/2008/04 ... -read.html

Hope you guys find it useful