DSXchange

Hi All, Is there any point in keeping Lookup Failure to Continue if Lookup Condition has been set to Fail. The latter condition will always abort the job if the lookup fails.Please enlighten me. Thanks in advance. How can you set the Lookup Stage to Fail and Continue at the same time? :roll:

The same system variable exists in Parallel. But each node has it's own @INROWNUM, so in order to get a unique number you will have to use the variable for the partition number as well (I'm not at a DS client now so cannot check what that variable name is, but you can find it in the drop-down menu)...

<UDBDB2STAGE>,0: DB2 Load Binary Error. <UDBDB2STAGE>,0: SQLCODE = -27959; SQLSTATE= <DSScratchpath>/ordb2195388278623545_ <UDBDB2STAGE>,0: SQL27959N The partitioned database configuration option "PARTITIONED DB CONFIG" is invalid. Reason code = "1". <UDBDB2STAGE>,0: Failed open...

How to write condition for stopping the sequences.. for ex:- suppose there are three jobs activities is there in sequence Like this type A ---> B ----> C i want to run A and C .. Not B then how to write trigger condition... Put a nested condition activity stage after the job A... put a trigger for ...

Hi i have a job designed for scd2,in the target i have 2 tables historical and current table. My question is how to move records from current table to histotrical table my client wanted to do this weekly once. Help would be appriciated a lot. what is your target table structure? What are the column...

Hi we are using ODBC as target stage, and there is a column sn_key in the target ,it has values starting from 1 to sequence ..... That extra column is genarated and values pased in the target only. How to achive that ? What is your database? You can either make that column a sequence column in your...

I have 2 columns from 2 separate sources. 1. Row count from aggr stage. 2. Process_id from surrogate key gen stage. At any given point of time there would be only 1 value coming in from each of these stages. I need to combine these 2 into one row output. How could I achieve that? I tried lookup but...

all, i'm using two stagevariables as mentioned below. Stagvar1: If ((IsNotNull(Column1)) or (IsNotNull(Column2)) Then '0' Else '-100' Stagvar2: If (IsNull(Column3)) Then '-Z' Else (If (IsValid('Date', StringToDate(Column3,"%yyyy%mm%dd"))) Then '0' Else '-200') stagvar3: If stagvar1<>0 The...

It depends. You can tune memory consumption in the Sort stage explicitly for that stage. And "performance" needs to be defined. ... Thanks for the reply Ray.. Performance can be defined as : 1) Better throughput from the join stage or improved throughput from upstream stages/operators 2) ...

Lets say input column is A

use the following in your derivation or stage variable

Set first Name To The following derivation:

A[1,Index(A,' ',1)]

Set Last Name to the following Derivation:

A[Index(A,' ',1)+1,Len(A)-Index(A,' ',1)]

Hope this helps...

Sort stage is more flexible about using memory - you even have the ability to specify the per-node memory usage that the stage takes. Also, with an explicit Sort stage, it may be that your job no lon ... Does using an explicit sort stage yield better performance as compared to a Link Sort? How does...

There is a job which does a left outer join (using Join Stage) between two links : Link1 - 30 million rows Link2 - 10 million rows (Right Link) When i use the explicit link sort (hash,sort) on both these links on my join keys , the job aborts after running for some time with this fatal error: buffer...

There might be just 1 function but below is the logic that should work within a TRANSFORMER stage Let's say data comes as "20070112.0" (1) Step1: Get everything before decimal (2) Step2: Data is now in YYYY-MM-DD format. So use StringtoDate() How to do that:- (1) Find position of decimal ...

It is documented that two adjacent Modify stages is not supported. Place a Copy stage between them if you need two. ... Yes, that's right ... Josh, yes there is no scale specified but as you mentioned it does come in as 20070112.0 Explanation of the problem's given below when there is a string_from...

Hi, One of the tables has an input column of Decimal( 8 ) which contains values: 20070112 20060513 which are in the yyyymmdd format I was thinking of using a modify stage to do this conversion but how can i write a single specification with two datatype conversions. I know you cant write two specifi...