DSXchange

Hi All, I have Job scenario like below. source --> Aggrigator1 --> Aggrigator2 --> O/p my source has 3 columns. col1 as integer,col2 as char,col3 as integer in Aggrigator1 I'm doing Calculation Sum(col3) --> col3_sum and minimum value(col3) --> col3_min For Aggrigator1 col1 and col2 are group key va...

In look up stage use multiple records from reference option.

In join it will do cross join. Cartesian product.

Step 1:

Usea filter stage apply condition f1 = N and f2= N
you will get all key columns having both non key columns value N.

Step 2:

use look up stage with step1 out put as reference. join on the Key column
use reject link for lokkup failure.
the data in Reject file will be your desired output.

Use Stable sort in the Join stage u will get desired output

Hi Ray, here it will convert any blank space in "0123456789" with the InLink.TheString and that with the single character which will be 1st character of InLink.TheString and then will be compared with "". I did not get what your are trying to tell. Can you please explain how the ...

Agrred. I had tested above cofig files. In datastage manager with check option there were 0 errors. I have do not have any problem with node pool. problem is with resource disk pool and resource scratchdisk pool. they are present in the configuration file but i'm not able to view them in the Node Po...

Hi All,

I have very basic question here for windows machine how do i compile it.

for my setup
compile:cxx
compiler option :-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c

i have one sample program also now?
but not able to understand how to compile and from where to compile?

Is there a reason you have only one node? Well i was wrong my machine iual core CPU so that means it has 2 CPU. Can you tell me is the 2nd Config file that i have mentioned earlier is correct? For resource scratch disk pools you have mentioned 2 pools. {pools "" pools "sort"} is...

Default Config: { node "node1" { fastname "W2PZ2MMX03" pools "" resource disk "C:/Ascential/DataStage/Datasets" { pools "" } resource scratchdisk "C:/Ascential/DataStage/Scratch" { pools "" } } } New config { node "no2" ...

Hi All, I'm trying to create new Config file "con1.apt". I have following problem. I have created new config file and removed the default node from it. removed default resource DISK AND SCRATCH DISK. i have add two pools for each resource disk,scratch disk and node. i have not included any...

Hi,

Single Sort stage will not do here. because two key columns in a sort stage means value for both the columns will be considered at a time.
so all will have change code as 1 until a record with both key columns repeats.

How about DateFromDaysSince() with an offset of -183 ? ... Depends on the definition on 6 months. it can be either that or if(link.field[5,2] <=6) Then (link.field[1,4]-1):12+link.field[5,2] - 6 else link.field[1,4]:link.field[5,2]-6 Why offset -183? will it suffice leap year and non leap year

you will need two '-' in the source date format. it does not have '-'

use following code in a stage variable and use stage variable in constraints.

If (MonthFromDate(DSLink2.date) > (MonthFromDate(CurrentDate())-7)) And (MonthFromDate(DSLink2.date) <= (MonthFromDate(CurrentDate()))) Then 1 Else 0