DSXchange

Just set the Record count to 0 mean it will only commit at the end of the job.

Look at Pg 224 of Parallel Job Developer Guide for V8.5 give you a good example on the usage of Re-calculation.

Hi

Did you check with IBM Support on any patches available?

In term of performance pure Insert or pure Update is always faster then Upsert. If due to certain biz rules, we've to use Upsert then we need to choose wisely on whether Update then Insert OR Insert then Update as there's performance differences as well depend on whether you've more Insert/Update da...

For Oracle EE, it is supported for -
1) Oracle 11gR1 based on 7.5.3.
2) Oracle 10gR2 based on 7.5.2.

You can use the multi-instance in the Job Properties if that's what you're looking for.

Am I right to said that you've never use the DB2 Enterprise Stage to access DB2 before as from the info provided you only talk about accessing DB2 using DataStage Server? There is a long list of steps to configure before DB2 Enterprise Stage can be use. Refer to Pg 6-14 of Install and Upgrade Guide ...

Multiple instances of DataStage exist since V7.x but only offically supported on V7.5.x and only run on UNIX or LINUX. Reason to install multiple instances of DataStage 1) Test out 7.5.1 without uninstalling an earlier version 2 )Test installing a version of DataStage 3) Install a concurrent version...

This will be a global setting within a job if you specify it as part of Job Parameters. $APT_TSORT_STRESS_BLOCKSIZE = [mb] When the memory buffer is filled, sort uses temporary disk space in the following order: Scratch disks in the $APT_CONFIG_FILE "sort" named disk pool Scratch disks in ...

"Suppose you want to configure the parallel engine to recognize an eight-CPU SMP, for example, as two or more processing nodes. When you configure the SMP as two separate processing nodes, the parallel engine creates two processes per stage on the SMP. For a 3 stage job, configuring an SMP as ...

the auto insertion of partiton and sort happens only if we have auto partition (Datastage). Kumar, Now i am bit confused. For me,Insertion of tsort operator is done even if we hash partition the data with no sorting options. Hi, There is no confusion as the requirement for join is to be sorted. Ple...

I need to call a Stored Procedure stage where my input is 3 params and output is 2 parameters one of which is a Cursor which is returning a 3 row-2 col result set. Can anybody tell me how to catch the output result-set in the STP stage? i.e. how to define in the PARAMETERS Grid? Please let know. Th...

Hi, I have a job that does the sorting in Database itself. Is there any way by which one can prevent the join stage from sorting the input data again. Thanks Senthil Hi By default sort is added as you can see it in the score, as this is how DS EE ensure correct results in join. The method to preven...

Must Join stage have sorted inputs (all or any one) :?: It is recommended to sort before join so that the join will be more efficient. If you're sorting than all sources must be sorts the same way before join. It is even better to sort using the RDBMs if the join is already indexed in the RDBMs so ...

On teradata Enterprise stage I have Auto partition. Configuration file does not have any node defined for Database, in this scenarion how can teradata load can happen on multiple nodes? How is data partitioned (if on different nodes) when datastage loads it to Teradata. Hi In Teradata the data is p...