DSXchange

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...

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...

Hi,

I want to sort some columns and order by descending.
number,code
and i want to keep the same sort in following stages.

Hi,

.
if CustID[1,1] = '2' then Address
Else if CustID[1,1] = '1' then StageVar1
else setnull

for above logic what sort is required.

order by number,code desc

shall i enable the sort in the transformer stage.

Hi,

Search with vertical pivot.

Hi, i believe the stage variable will only hold current processing data and it will not go back to previous data. loop will run when in sequential mode. f CustID[1,1] = '1' then we have to go for CustID[1,1] = '2' address values. if not correct please correct me. or shall i have corresponding code 2...

Hi All, 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 I have to write a logic if code starts with 1 the populate corresponding Address column based on CustID strucked with the second logic else if code sta...

From source itself im getting as decimal value.
how can i convert.
please suggest me.

Hi, I'm reading from fixed width file. in that i have a amount column starts with + or - i.e -10.00 -12.12 +14.98 +25.78 im reading the file as squential mode. i want to sum the column + seperately and - values seperately. and finally differences for + values and -Values. how can i acheive this.

Hi,

how to convert this into (13 NOV 2008 21:06) timestamp format

Use NOT in Query to select unmatched rows.
(or)
Check for Null values in Transformer and then populate

It seams like records not joined.
Better to trim the key columns when creating lookup file set.
Use Trim function in Source also.

Regards,
LakNar

do u have any contstraints in Transfermer Stage.

Hi ann_nalinee,

Check the Transaction size of DB2 input Tab.
try to split insert and update.
for update and insert the default should be 1.
hence this checking for each and every record.

or better use before sql to delete entire table and load.

Regards,
Laknar

Hi Ray,

two doubts one is regarding Null Handling.
Another is UNIX Script in Jobs both in row level and One time execution.
Please suggest me.