DSXchange

Hi,

I need to suppress the left zeroes in a string.
For example : '0000525600254000' ==> '525600254000'
Does anyone have an idea ?

Thanks
Matthieu

Hi,

Are you sure your input file exists ?

Matthieu

Hi, I used change capture. I don't use PX for 4 month, but I remembered it works well. If the change capture allow to have only the new lines and the modified ones and you need to keep the before lines also, may be you should add a funnel. Analysing modified, new, old [...] lines by a join stage is ...

Euh... the name of the stage is "remove duplicate".

Have fun.
Matthieu

Hi, If I understand your problem, I think you have a very better way to do this. First step : partition by "deptno" Second step : sort by "sal" with the sort stage (descending mode) Last step : use the stage which permit to have unique record on a key (I don't remember its name)....

HI,

1) There is a space between "666," and "667" in your query.
2) Are your sure you are not supposed to use "." as decimal separator.

Good luck
Matthieu

We use a query like this : SELECT KEY, Field1, Field2 FROM TABLE WHERE Field1 in (#PARAM1#) OR Field2 in (#PARAM2#) PARAM1 = \'VALUE1\' PARAM2 = \'VALUE2\' If we don't use \ then the query is seen like SELECT KEY, Field1, Field2 FROM TABLE WHERE Field1 in (VALUE1) OR Field2 in (VALUE1) and doesn't w...

Hi alone,

You have to put \ or / (I don't remember) before the quote.

Have fun.
Matthieu.

Hi nivas,

Try to monitor the virtual memory. You may not have enough space.

Good luck
Matthieu

Yes I'm talking about PX job. As strange as it seems it works with Datastage 6.0.1 version (I don't know with 7 version) ! We tried this after many problems with the conversion from string to decimal. About 5% of the datas with decimal values were wrong when a sign was included in the numeric field....

hi Jay, The right formula is : StringToDecimal(convert(".", "", Link.ColumnName))/1000. In 6 version (I don't know if it works with 7 version) of datastage you can also use a transformer to convert a varchar into decimal without any convertion formula like 'stringtodecimal'. Just...

Just a precision.
I don't know why (may be something with the buffer) but in the transformer you use this formula you have to declare the field as decimal(11,3). If you really need to change to decimal(7,3) (not needed for Oracle) add a second transformer.

Bye
Matthieu

Hi,

I found something for you.
Try this : DecimalToDecimal(StringToDecimal(convert(".", "", Link.FIELD))/1000, 'round_inf')/1000

000000000002.423567 -> 000000000002.424
000000000001.423467 -> 000000000002.423

Ciao
Matthieu

Hi,

Declare your field in the sequential file as string 18 and try this :
StringToDecimal(convert(".", "", Link.Field))/1000000000000000

It must work... tell us

Bye
Matthieu

Hi,

I had this error. It was a partitioning mistake. Check all your 'advanced' properties and your 'partition type'. If you don't find anything wrong try to extract in sequential mode from Oracle.

Good luck.
Matthieu