DSXchange

by default lookup fileset will use entire partition.

Converting decimal to string using TX Stage before joining.

Converting decimal to string before creating look up fileset .
Converting decimal to string from DB2 Stage before lookup(Using TX)

Hi,

When i see the data from DB2 stage
12.900
From Lookupset
00000000000000000090.710

I believe due to this records not joined.

Hi,

Input stage is DB2 API.

Hi,

I have created AMOUNT as Key Column in Lookup file set(datatype Decimal).
And the same im using in next job.

But the match found(checked with query).But not coming in Lookupset expected result.

Hi,

source ----------- insert
|
Change_Capture---------File_generation
|
Exixting----------- Update


in insert delta indicator is 1 constraint
file indicator 1 and 3
update 2 and 3

Hi,

We are doing delta capture.
first i am processing the record with 40000 records.

in existing table 40000 records have been loaded.
again i am loading the same 40000 records into same table.

its generating the new records into the file.

Hi,

Is it need to assign any Initial Value for the stage variable.

Hi,

Can you please explain the below functionality,how it works.

if CustID[1,1] = '1' then DSLink1.Address else StageVar1

simply populate your output column with StageVar1

Number amount currency Code CustID Address 123456 10.00 22 21 123 London 123456 10.00 22 11 234 Chennai Address Table CustID Address 123 London 234 Chennai I have to findout duplicate based on Number ,amount,currency columns and if code starts with 2 and populate corresponding address. Else if code ...

Hi Mike, Number amount currency Code CustID Address 123456 10.00 22 21 123 London 123456 10.00 22 11 234 Chennai I have to findout duplicate based on Number ,amount,currency columns and if code starts with 2 and populate corresponding address. Else if code column start with 1 then populate code star...

Hi Mike, Number amount currency Code CustID Address 123456 10.00 22 21 123 London 123456 10.00 22 11 234 Chennai I have to findout duplicate based on Number ,amount,currency columns and if code starts with 2 and populate corresponding address. Else if code column start with 1 then populate code star...

Hi Mike, Number amount currency Code CustID Address 123456 10.00 22 21 123 London 123456 10.00 22 11 234 Chennai I have to findout duplicate based on Number ,amount,currency columns and if code starts with 2 and populate corresponding address. Else if code column start with 1 then populate code star...

Hi,

can any one advice me regarding this

hi ray,

I have tried.but im not getting the expected result.
bit of confusion with the sort.

db2stage------lookup-----TX------Dataset

sorting the code by descending.
how can i keep the same in next stages.

I have two tables one is code and another is Customer. Number Code CustID 123456 12 123 123456 22 234 CustID Address 123 laknar 234 standard if code starts with 2 then corresponding address from customer table. if code starts with 1 then address column of code[1,1]='2'. this is my logic.please advic...