DSXchange

Use a filter on the Sequential File stage. As the filter command use sort -u to remove the duplicates. Specify the sort keys using the appropriate form of command line arguments (for example -k1,2)

Jim, Somehow or other you (or someone else at your site) has managed to create two things with the same name - two job names in a batch is my guess, but it might be two parameters in a parameters collection, etc. Alas, without inspecting the underlying repository tables, it's impossible to test this...

There's no log by default, but you can start the RPC daemon in debugging mode by specifying -d9 as a command line argument and redirecting its stdout and stderr to files other than .\NUL or /dev/null. In Control Panel (Services) on Windows, find the DataStage RPC services and add command line option...

"Connection reset by peer" indicates that something, somewhere in the network has dropped out. It is most usually a timeout - perhaps an inactivity timeout, as no traffic passes while rb_tmu is running on the remote machine. You may need to increase the inactivity timeout for the rsh connection.

If you cleared the status table (RT_STATUSnn), then you have made it very difficult for DataStage to figure out which unique instance (wave number) to run. Recompiling the job ought to fix things.

You could pass the result back through any of the @USER0 through @USER4 system variables, and return 0 through Ans.

The value of nn is always 30 for dynamic hashed file. Static hashed files, however, do not have this structure; they are implemented as ordinary files (though they are not text files). The utility $DSHOME/bin/UVfile will test something to report whether or not it is a hashed file. find . -exec $DSHO...

That is a very annoying warning. Red Brick generates a warning if you execute an UPDATE statement that processes 0 rows. DataStage logs that warning. I have never found a workaround for it. The only "solution" is to intercept that particular warning in the controlling job sequence and bypass it when...

It is possible. It is not easy - you need to query on undocumented columns (in particular the parameters collection in DS_JOBOBJECTS in ROOT records) - with a join to DS_JOBS to get the job name.
I might get time on the weekend to post something, if no-one has done so before then.

"Guru" is much better word; your English is still FAR better than my Korean! I think you will need to ask an Informatica specialist how they get Oracle loaded so quickly, and whether they use SQL*Loader to do it. (If they have created their own software maybe even Oracle would be interested!) There ...

Hello DaeHwan, Please check "Glue" in your English-Korean dictionary - it was not quite correct, and was amusing. I do not think anyone on this forum will have any knowledge about the strategy that Informatica uses, but you might be lucky. I can't believe they would not use SQL*Loader, but they may ...

Use Transformer stage to conditionally or unconditionally direct subsets of fields.
Whenever you write "fields to rows" think Pivot stage.

I would advise not posting in inappropriate forum. The correct forum for server job questions is the server job forum.
And you do not shout (capitals) and you do not shout in red. It is offensive.

It means that there are more components in your date string (first argument of TO_DATE or TO_CHAR) than are specified in the date picture (second argument).
Search the Forum for detailed examples. It's been covered on a number of occasions before.

You could always use Change() or Ereplace(). For example