DSXchange

Of course you may have been confusing should with wood.
(See my earliest post on this thread.)

For instance join's can only be across two inputs and there is no reject link, ... This is not the case. A Join stage can have more than two inputs. In this case pairwise joins are created as intermediate results, the same way that databases do it. The "other" inputs are referred to as In...

A joiner is someone who assembles wooden furniture, particularly cabinetry. Your choice is therefore clear.

Unless, of course, you are loading large amounts of wooden objects...

When's the interview?

What about NPROC (the number of processes that any one process can start)?

The best way is to use DataStage Designer.

We really do not like to answer what are patently interview questions, as we believe that interview questions should be answered on the candidate's own merits.

Begin by reading the Parallel Job Developer's Guide then post any specific questions that you may have. You control where Data Sets and File Sets are stored, and you would need to define what you mean by "performance" in an ETL context (rows/second is an almost meaningless metric). Every s...

Begin by reading Chapter 2 of the Parallel Job Developer's Guide then post any specific questions that you may have. As it stands your question is too vague. There is no single "best" algorithm, there's no general solution to "optimize parallelism", and you would need to define w...

marcelo_almeida wrote:However, I need to do this in a basic transformer inserted in a parallel job.

Why?
If there's only one record then a server job will be far more efficient.
And then you can use UtilityRunJob properly.

But do you have SELECT privilege to the eight system tables that you need to be able read? This is described both in the manual and you can find it here by searching.

My guess is that you've hit some kind of limit in the number of files (or, perhaps, the size of the string) that can be managed as the result of a regular expression (your file pattern). Check both with your official support provider and Microsoft (probably most usefully MSDN) about whether such a l...

Do you have Metadata Workbench?

I'm not able to check now. But the Sequential File stage definitely has it, as does the Column Import stage.

.00 and .12 are correct. With Decimal data type you can not affect the format (it's actually stored internally in binary format). If you convert it to a string data type of some kind then you can affect the format, as you seem to be trying to do. You are discarding the sign character ("-")...

No, it was just a bullet point on the DataStage roadmap presentation at IOD 2009 conference last October.

Well, if that is the case, and the FTP is from OS/390, then your assumption is correct - the FTP stage has no way of identifying a particular partition. You would need to have the partition dumped into a sequential file of some kind. If you have MVS edition of DataStage, you could create a mainframe...