DSXchange

I have a dataset which i am trying to view and the OSH code for the same is : ################################################################# #### STAGE: Data_Set_312 ## Operator copy ## General options [ident('Data_Set_312'); jobmon_ident('Data_Set_312')] ## Inputs 0< [ds] '/data/ds/hbus/dev/etl/...

Hi I have used all options with orchadmin describe which shows me the number of records per partition but i am not able to check the number of records per segment, is there any other way to get to know this? Also the orchadmin shows 2 segments for a dataset but the Dataset management utility shows o...

In terms of orchestrate and scratch disk they are the same as they end up with the same tsort operator.

Hi

We have installed DataStage over one unix server and Database (DB2) over another server and when we use the DB2 stage how does datastage traverse through and end up into the another server where database is installed, could anyone please highlight the steps that datastage follows at high level.

At a high level could you please guide how ?

Hi

I just wanted to know if we can directly write orchestrate code without creating the job with the designer and then compile this code and can run it ?

Data Sets carry four additional fields (per record) used for recording the structure Could any one please through some light over these extra columns in additon to the mentioned sort order and what i am curious is the varchar fields taking up the defined space and always the discussion says they ar...

Hi

can anyone throw some light on standalone.sh regarding what it does and its functionality

If you are having specific count of files to read then you can use a transformer and create a column with deriavation as @OUTROWNUM system variable instead if you are not sure of how many files you would be reading each time then you can specify the multiple files to read option in this case you wil...

what i am curious is what sense does the encrypted value make unless you are able to decrypt it which i guess is not possible

consider I am having 2 records:

A B
100 1
100 2

if i partition on col A i will have both the record in same partition but if i partitio on both the columns is there a chance that the records may end up on different partitions ?

chulett wrote:Use a modify operator to specify the value to which the null should be converted.

Yes i can use a modify operator but in case i do not then what happens.

The modulus partitioning divides the key value with the number of partitions and uses the modulo value to decide which partition the record has to be placed....... keeping this in view what happens when the key has null? does it replace null with 0 . It is giving me a warning if i use this partition...

Throught the discussion i was talking about the partitioning over the sort key........

Many Thanks Ray for you clarification
I was with the impression that when partitioning algorithm runs over sorted data it may disrupt the sort order of already sorted data which is now clear that i was worng.