DSXchange

Thanks everyone for your patience. Looks like my question is misleading everyone. I am not trying to fix or coding the logic, someone else developed the job and trying to know how it will work. As you said: Since " " doesn't convert to a valid number, it is comparing the multi-byte char fi...

@asorrell .......

what it was doing comparing char with numeric....... how can it be true ?

asorrell.....Thanks !! Well, here I want to know functionality how it works. At look-up stage options are continue , continue... So it will not fail now. When I am doing IF NUM1>0 THEN 'Y' ELSE 'N' at Xtrm....how does Datastage validates..... When mismatches NUM1 will be spaces....then space >0 will...

I have a question on lookup. For both Source and lookup, I have Oracle Enterprise stage and after lookup, a transformer is there. In the transformer there is code: IF NUM1>0 THEN 'Y' ELSE 'N' NUM1 is coming from lookup stage and is is Char / Not Null. My question is about what happens when the data ...

@bart12872 ...yes I will get only XY1, ZX1 and YZ1..................Whatever these Id numbers should be stored as in vertical colmns

Hello Everyone, Input ---------------------------- ST_ID CT_YS CT_ID ------------------------------ 1 XY1 100 1 ZX1 200 1 YZ1 400 1 YZ1 300 1 YZ1 100 Expected Output ------------------------------- ST_ID XY_ID ZX_ID YZ_ID ------------------------------------------------------------ 1 100 200 400 1 1...

My bad......The function which i am using working fine.

I dont have any spaces here ....double quotes first place and in between or end.

Hello Everyone, My input data comes like "ASH" or SRI"RAM" when its loading to file ......its loading as ""ASH"" or "SRI"RAM"" I want to trim " (quotes)..... expected output is -------------------------------- "ASH" "SRI...

we got the following ERROR: 049 22:51:52(000) <main_program> Parameter specified but not used in flow: DSProjectName [osl\osl.C:623] When we restarted it RAN fine.........but I am not sure how it worked......did anyone faced this Issue ? how u guys sorted it out ? I just want to know why this caused...

asorrell


Records will not Reject.................Every record should feed into the table

Thanks Ray.....


I can send the records based on constraints in the transformer.

But my Issue is bit different....

When a Insert record comes till it commits it should not allow other record to either update or delete............there should be delay and every record should commit one by one

Well there are several transaction need to load in the same way as in file...


how can we do Insert, update , delete ?

Hello Every one, I need a logic ..... I have a input file...........It consists of Inserts, Update's and Delete. What I mean is ,suppose if I have 100 records in file........It should be load in to the table sequentially (Either Inserts, Update's or Delete have to commit one after and another) Can a...

chulett Thanks for replying....

I changed input string into StringToTimestamp(date,"%yyyy-%mm-%dd %hh:%nn:%ssss") ......


Now i want to load all 4 bytes into seconds position....... is it possible ?

If so in place of %ssss what should i keep