DSXchange

Not the same issue, because not the same symptoms. Open your own thread if you want help with your particular issue.

Hadoop does not store compressed files in this sense. How are the data being retrieved from Hadoop and written into an archive? Yes, you could use an External Source stage. If you have version 8.7 or later, why not use the Big Data File stage to access data from Hadoop directly? (Acutally it uses Ma...

It does. Click the "generate report" tool in the Designer toolbar.

Not me. I remember all my passwords (about forty of them, all strong).

Windows DLLs. (Makes sign to ward off evil eye.) Have you installed any other software with conflicting DLL names?

You only waited three hours! Not everyone is on line 100% of the time.

That's impossible for us to know. If you re-compile and re-link in the new environment all required files should be created. Otherwise you will need to research what files are needed on YOUR system.

Don't forget that system table names must end with "$". So, if your worksheet is to be called MySheet, then the table name used in clients (whether DataStage, MS Access or whatever) needs to be MySheet$.

Does the write sheet exist and have column headings in place? Then you can import its "table definition" just like any other sheet. And write to it, provided that the executing process has write permission to the workbook. Beware that each worksheet is a system table to the ODBC driver for...

An old blog, I wonder if it's performance is any better now?
http://it.toolbox.com/blogs/infosphere/ ... exam-37272

Welcome aboard.

Check that the PATH environment variable is set appropriately in the new environment, by comparing with the old environment.

PATH is typically finally set in the $DSHOME/dsenv script.

Today's date is given by Date() therefore yesterday's date is given by Date() - 1 since dates are stored internally as integer offsets from a known day zero. Initialize two stage variables with these values so that they only need to be calculated once. If needed, use Oconv() functions to convert to ...

I support what Vincent says here. Note, however, that Business Glossary author/administrator are named licences - you have to be able to prove during audit that only the named individuals have access. Nearly got caught by this one a couple of engagements ago.

Change First Line is Column Names property value to False. Make sure that your metadata allow the header line to be read (even if you have to read each entire line as a single string), rather than be rejected/dropped.

If I use transformer stage to just filter records, Is it going to affect the performance as it's not native to DataStage ? On the other hand, the transform operator is a directly compiled component, whereas the filter operator is more like interpreted (not strictly correct, as it uses a pre-built o...