DSXchange

Try to put host name of computer C instead of D and the port number is 9080 by default unless it is different in your environment.

Thanks SURA for replying. We are running on 4-node AIX configuration. So you mean do hash partitioning on both the stream and the reference links? or just the stream or just the reference? I tried hash partitioning on the stream before and it did not help. I tried it on the reference and it gave me ...

Is it possible to use sparse lookup as reference link to SCD stage? If yes, what is the needed configuration? The volumes we are looking at eventually are ~ 20 million for both stream and reference. Right now the job is failing when the stream is just ~ 1 million and reference is ~ 12 million. The S...

I have recently faced the same issue and the workaround was NVL function. I found another thread here but again with no "real" solution: http://www.dsxchange.com/viewtopic.php?t=135601 However, I just noticed something, it looks like this problem is only when the field is a NOT NULL VARCHA...

ray.wurlod wrote:Overkill. All you need to trim is the @FM character. ...

I tried that in my first post but it did not work for some reason.

Thanks Ray for the hint. I echoed CommandOutput to another file and I saw that the CheckTrailerCount is actually storing CRLF at the end of it. I found a similar EReplace expression from another DSX thread here http://www.dsxchange.com/viewtopic.php?t=140129 and it solved my problem. EReplace(ERepla...

I am new to DataStage (my 4th month now) and this is my first post. I hope you believe me that I DID search before post but without finding what I am looking for. If this is not the appropriate forum, please let me know. DS version is 8.1 My input file has a trailer record that contains like this En...