DSXchange

You need to gain a bit more of an understanding of the Orchestrate framework. A virtual Data Set is associated with every link of the job - take a closer look at the score to see what I mean, even though in the score they're generically named (DS0, DS1, DS2 and so on) you can ascertain the associate...

Both, while there's still plenty of 7.5 sites around.

That's about 1600 rows per second. The bottleneck is almost certainly the "writing" stage. But you need to establish the timings of each - the select with and without the functions, writing to a text file versus loading into a database via bulk load versus loading into a database via SQL. ...

Sort by ID, generating a key change column. Based on the key change value, in a Transformer stage either accumulate a delimited list of values or begin a new record. Downstream of the Transformer stage use a Remove Duplicates stage to preserve only the last of each group. You're pretty much done at ...

TRUNCATE is a specific and separate privilege in Oracle.

madhav62 wrote:incoming data has field which is decimal(with two decimal places)

Sorry, I was tricked by this statement in your original post.

If it suits your requirements, the easiest solution is to use multiple File properties rather than read method "file pattern".

VarChar(9) is not big enough - you need at least VarChar(11) - you have nine significant digits, a sign and a decimal placeholder. Where do you expect the third decimal place to come from, given that your source column only has two?

Mine do allow you to add negative offsets.

Welcome aboard. How much memory is available on your client? The JVM for Information Analyzer is pretty big.

The short answer is a job sequence with intermediate activities to retrieve the required values.

The DB2 Connector documentation was left out. You need a patch to install it.

Probably in db2nodes.cfg. Check with your DB2 DBA. DataStage is just another client application as far as DB2 is concerned.

DSXchange Learning Center (through OnDemandStrategies)
PR3
LearnQuest
ProTech

The date components can be returned by system variables @DAY, @MONTH and Right(@YEAR,2).

But does "day + 50" mean that you will allow a day number of 81, or do you need to add 50 to the date then decompose it into components.

Please check out the date routines in this file.