DSXchange

Hi I am trying to substract two entries as follows: Field1 Field2 difference(Field1-Field2) 3458.90 3458.90 45621.12 -45621.12 When I was trying to do Field1- field2, the datastage is giving an phantom error "Datatype is not proper". I am having all three as numeric datatype. Even I tried ...

At present these are the expressions which I am using for Insert and Update


Insert : IsNull(Customer_lkp.Customer_KEY)
Update: Not(IsNull(Customer_lkp.Customer_KEY))

For First Insertion I am assigining the Flag to "Y"..(NEW)
If user changes the current_ind in target table to "N"
my job should be update only that record with flag set to "N"

For First Insertion I am assigining the Flag to "Y"..(NEW)
If user changes the current_ind in target table to "N"
my job should be update only that record with flag set to "N"

For First Insertion I am assigining the Flag to "Y"..(NEW)
If user changes the current_ind in target table to "N"
my job should be update only that record with flag set to "N"

Right now I am having only two links and
I am giving the rule
for Insert as : Insert new rows only
for UPDATE AS: Update existing rows only

Is this correct

Hi I am having my job as follows: I/P -->TX(lookup + constraint in TX for INSERT AND UPDATE)-->(NEWKEY GENEARTION(for insert new rows) --> Target table I am adding a flag in TX SAYING THAT IT IS NEW OR NOT (using "Y" for NEW and "Y" for OLD). Initially I gave "Y" for fl...

I got it..How to see the full links of the solutions

What is this Premium Contest

Thanks Ray.
Can you be little bit more clear Ray..

Its not that A appears only at the end of numeric values. It also appears in others like
procter&gamble-G&A

I do not want A to be removed here.

Thanks for the solution. Actually I am faced with a new problem now My data has changed in flat file and is like: 23231A 236376A 738273A 63721A ANGELIA CHAMELIA 773626A OUTPUT: 23231 236376 738273 63721 ANGELIA (HERE A SHOULD NOT BE REMOVED) CHAMELIA (HERE A SHOULD NOT BE REMOVED) 773626 This is som...

X is also removed if it is part of some other string, which i do not want..

Thanks

My requirement is osmething different.
There are certain columns which when null should have the value of the colno-1..If the col(x) is null then i am entering NA then if col(x+1) is also null, it should be NA.

Hope I am clear now