DSXchange

I don't say nothing but can this happen? Ray, we have our jobs which are 4 node configuration and jobs itself have some partition and re-partition within stages like Aggregator ( to sum calculations). When I run a sequence in DataStage through unix, I will have an ouput to verify the summation of re...

Sorry to get back late...

Actually, found a problem here..Everything works great in Dev env but The same job is not working in QA as it gives me the output with decimal with wrong data.


Any suggestions here...It is the same Oracle database for both dev and qa.

Thanks

pandeesh wrote:Please try

Code: Select all

Convert(".","",VALUE)

and let us know.

It's not workng out! I am still getting "."

pandeesh wrote:Please try

Code: Select all

Convert(".","",VALUE)

and let us know.

It's not workng out! I am still getting "."

pandeesh wrote:If it's varchar, then use Convert() for removing the '.'.

It's Char. But can try varchar. Any other suggestions?

jwiles wrote:Are you certain of the value of a_pay? What is the result of just DecimalToString(a_pay) without any of the other logic?

Yes the value is certain. I didnt try just DecimalToString. Is there any possibility with the logic I could remove the "." if it comes?

ray.wurlod wrote:What's the actual value in a_pay (or similar) for the columns that work and the columns that don't work? ...

a_pay has +000150000 and I am mapping a_pay to apay with the above said derivation

Note: a_pay is different data now since I mock up test bills. Still there should not be +.00000150000

I am deriving an aggregation column which is a_pay (decimal 11, 2) and writing to a transformer apay (char 12) with the below derivation. "+":Right("00000000000" : DecimalToString(NullToZero(a_pay) * 100,"suppress_zero") , 11) Somehow, I am getting "+.0000000001&qu...

Sorry for the typo

it should be "000000222" 9 bytes and no decimal in target.

Hello, I am trying to use DecimalToString finction because the source columns field is decimal and it is mapped to target field which is always char. Incoming data is like 0000002.22 is what the file has now...10 bytes with a decimal. I want to take the decimal out an the final should be zero pad to...

I am reading the DB2 tables, not the sequentila file.

I have looked at the DB2 tables which is AS/400, the table definition are having packed decimals and xoned decimals. But packed decimals is working fine. Problem is with zoned decimals where I cannot view the data in DataStage.

Hi All, I am trying to migrate the data from DB2 (source) and SQL (target). In DB2, some tables are having columns with datatype as Numeric. When I try to view the data, the data represents in "?" wherever the columns has the datatype as numeric. From the DB2 level table definitions, those...

Perfect! Saw the difference, query is correct and I got the record count as needed. Thanks chulett!!!

Typo!! I am sorry, it is -7. So the query which am using is correct?

SELECT count(1) from table name WHERE etl_timestamp between getdate()-90 and getdate()-7

Hi All, I am trying to take the result from DW table where I need the record count between last 90 days to last 7 days. I am trying with this query and am getting the result, but I dont know I am doing the correct one. My query is SELECT count(1) from table name WHERE etl_timestamp between getdate()...