DSXchange

The wc -l command reports the number of lines in the file. If it can count lines, then there ARE line terminator characters. Your original suggestion, that there are none, is disproven. You can get a Windows server to read UNIX files using a gateway such as samba. Or you can FTP the files from the U...

The External Source stage executes a command (possibly a shell script). That command's stdout becomes the output of the External Source stage. Assuming you have a script that can "read a file from a URL path" (whatever that involves), you can pipe its result through tail -1 to get the last line. If ...

Being in a different city, often a different country, every week I feel no need to own either a car or a television. Which is why - at least for me - neither car dealerships nor cable television companies are necessary.

In this post Ken claims that cable television companies and car dealerships are necessary evils. It occurs to me to ask in what way either of these is necessary.

Yes. Either your network administrator or your Oracle DBA.

Enrol on IBM's DataStage Essentials class, the entry level class. This is one of the techniques taught.

While DataStage does not "display" anything (it runs as background processes), what you are describing is precisely how the lookup mechanism in the Transformer stage works. Supply the reference key expression with the input value. On the other end of the reference input link have a stage type that a...

It has since occurred to me that step 1 (extraction of the month number) could readily be achieved with a MatchField() function.

XP pro can be made to work, but is not officially supported. And then only with version 7.5x2. And you will need a patch if XP has sp2 installed.

You would have helped yourself by creating a written specification. Your input data is of the form "CD(m+n) yyyy" and what you want out of this is the month name corresponding to m. Is this correct? Break down the specification into algorithmic steps. 1. Extract m from input value. This is the value...

Given that the original post specified "same configuration file" I guess the question is whether the job that populated the Lookup File Set used the default node pool or was constrained to operate in a particular node pool at that time. However, it's much more likely that there is a problem with nod...

URGENT is an unusual name for a data source. Etiquette Note We don't do "urgent" requests here. All contributions are voluntary, in unpaid time. We post as and when we can. If you need urgent answers, sign up for premium level support from your support provider. You will find that urgency comes with...

It is not possible to have true duplicates without the hashed file being damaged. <pedantry>Non-printing and space characters are not duplicate keys.</pedantry> Although they may appear to be, to the human viewer. There are a couple of ways that duplicate keys can occur in a damaged hashed file. One...

Connectivity failures, including network, database server, authentication errors (e.g. wrong password) and more. These should be immediately fatal. Violation of security and/or integrity constraints (most usually primary key uniqueness constraints), which should be prevented in your design. Property...

Why not FTP both files from the UNIX machine and load them into DataStage with a filter (type file1 file2) in a Sequential File stage? Specify the stage properties as no line terminator, and the record as fixed-width format. That way the column display widths will completely specify the row structur...