DSXchange

Data might be valid, but how about join?

Nodes will not be generated, but the readers (operators) are.
Reason for the fixed width file would be, it can use Memory mapped IO. In case of delimited file, the reader has to read sequentially to find the delimiter first.

Client installed in other PC is different from you PC. Contact your support or you can download it from here as well.

It is number of readers per node. Hence if you specify 3 readers, it introduces 3 Sequential file read operator for each node. And hence you will have 6 in case of 2 nodes.
But effectively all the 3 readers will be reading a single file on a single node, which is mostly by a single CPU.

Hi tsanan, Welcome aboard!!! :D
If you have installed your client in your PC, you can find the necessary guids under Start-->All Programs-->Ascentail Datastage-->Online Manuals.
Which actually resides under the path what Ray, had given.

You can call UtilityAbortToLog for any special cases checked from the transformer.

tablespace warnings/errors would be followed by the job getting aborted

It is other way, the job will be aborted due to these tablespace issues.

Error gives you the information that, the delimiter that you set in sequential file (may be ',' or '|'...) is not available even after reading 100,000 bytes.
AS the name implies, you can use the XML Input as your input stage.

Have you checked the avaialbility of space if you are more doubtfull in it?

Check the same query to execute in Command prompt or in some Toad in database.

Comming back to OP's concern.
Vijay - For testing again, incremetally add one stage (Transformer, Filter, SORT and Aggregator) after dataset and insert it again to another dataset, and from which you can nail down the bottle neck.

Reg 'Borat' - WIYF (Wiki is your friend.)

Or @ Ascentail site

Since the input you have, just gives the size inoformation, I again assume that you are after Disk Size. As mentioned, it all depends on the level of transformation involed. What is your source/targer? Is it generally a daily run/weekly/Fortnightly/monthly run? Based on your high level desing, how m...

Hi peterxu, Welcome Aboard !!!:D

What difficulty you face while reading the XML file through sequential file stage, afterall if you assume it as an flat file
You can see some dedicated XML stage available for this. Try that out.

If you need to use Sort stage, leave out the ORDER BY in your query. And what error msg you are refering to?

If you had the column in the source and if you had renamed or dropped in some intermediate stage, RCP will be culptrit.
Else, since its the sequential file, you can go ahead to chage the column name from the source stage.