DSXchange

any inputs?

All,

Our configuration file has 3 nodes. This file is being used in all our jobs. When I run a job, will it use all three nodes for its processing? or will it use 2 nodes and the remaining one for operating system processes?

Inputs are welcome!

if partition insertion is not disabled...

How should i check this?

$APT_NO_PART_INSERTITION = Flase

Do i need to include this in the job to see which partition is used by defauly?

I have also seen this on

http://www.pickwiki.com/cgi-bin/wiki.pl ... AMVedit_AE

it seems like BASIC SUBROTUINE written in the above link.

viewtopic.php?t=143353&highlight=basic+transformer

You can use a BASIC Transformer stage in a parallel job.

I am really curious to know the meaning of 0X1N0X

Hi All, I have read and often heard about BASIC Transformer stage in parallel and just transformer stage. On what basis we are saying it as BASIC Transformer stage in parallel ? how should i know whether the transformer used in parallel job is basic or parallel? I have searched here and tired for no...

All, I am little bit confused on "Preserve Partition" topic. I can see four types under this, Default(Set) or Default(Propogate) ??? i can see either of them. Clear Set Propogate For some stages, I couldn't see propogate. i usually won't change this property. But..i just wanted to know whe...

All, I have read about Sort stage on "Parallel Developers guide". I didn't see which partition will be take by default by the datastage. may be "Hash". (if it is a varchar and more than one column) or may be "Module". (if it is a numeric and only one column) which one i...

Ravi.K wrote:If you want to see what partition Datastage selects when you select Partition as Auto then enable Dump score Environment variable to trace the Partition method.

I have included $APT_DUMP_SCORE in my job. But i didn't see the partition used by the datastage by default.

All, I have designed a simple job to capture the changed data. Content of File 1: col1 col2 1,a 2,b 3,c 4,d 5,e 6,f 7,g 8,h 9,i Content of File 2: col1 col2 1,a 3,c 4,d 10,e 6,f 7,g 12,h 9,i 1111,k File1 ---------->Sort -------> Change Capture ---------------> Output File File2 ---------->Sort -----...

emp_id will be chosed as the key for hash partition for #2. right ?

All, I have desgined a simple job. SeqFile Stage (only one file) --> Filter Stage --> Dataset Stage I just changed the "Number of Readers Per Node" value to 2,3,4,5 and monitored the job score. main_program: This step has 3 datasets: ds0: {op0[3p] (parallel Sequential_File_0) eAny=>eCollec...

what kind of actitivities will be stored in resource disk? first of all, what is mean by resource disk? It is is a kind of Hard Disk. Am i corect?


As for as i know, the lookup data will be stored in scratch disk. Right?

It is a kind of RAM? Am i correct?

All, When i use Aggregator stage, i just use "Auto" partition type only. I mean i just leave the option to datastage. One of my collegue asked me the below question yesterday. my task is to get a) select max(salary) from employee by using aggregator stage. which one is best partition metho...