DSXchange

I was using the function above in a modify stage.


I was just asking that as I am using a basic transformer elsewhere in the job can I change the output datatype in that transformer like we do in the server jobs ?..... thnx

I am trying to change a CHAR to a DECIMAL using modify stage. My source is a DATA SET and the column name is "OFFER_ID". I am using OFFER_ID:decimal[8,0]= decimal_from_string(OFFER_ID) . This does not work. Is there another way to do this?. I am using a basic transformer in PX , so can I c...

I was using a "Left Outer Join"

I am using the inbuilt sort (Ascending, Case Sensitive) and the Partion type is "Hash"

I am joining 2 tables with a "left inner join" , The key combination I am using is promo_id and offer_Id. Table A(Left) has 117500 rows, Table B(Right) has 1490 rows. But I get 274470 rows as output ?. I really dont understand?..... can anyone suggest what seems to be the problem here ? Thnx

Find out who created the expression and ask them! Looks like a weird attempt to force an implicit conversion to string so that the Trim() function can be applied. But it's wrong. The proper way is to use an appropriate conversion function, such as StringToDecimal() in a Transformer stage or string_...

I removed it and tried to run .... it gives out the same output !

.....

Hmm ... thts wht I was wondering about .. Input datatype was CHAR 8, Output datatype is DECIMAL 8 , I thought that may be a reason why it was done so...

convert('.','',trim(l_SuperListInfo_1.ZPROMID :'' )) What does the text in RED mean?. The data type of the ZPROMID column is decimal. The column is being converted from CHAR to DECIMAL using a MODIFY stage and then before writing it to a SEQ file, the above derivation is given. Can anyone please let...

I think this project is for creating a SAP BW

I have never used fixed width columns format in any of my outputs. I recently took over some jobs which have fixed width columnsas output and inputs.

I dont understand the concept of fixed width and was wondering why we need Fixed width columns? Can anyone plz explain the use ?

Thnx

Actually I am testing some jobs rightnow, I have 1 file from the PROD and 1 from the DEV ENV and I compare these file record by record using a DIFFERENCE stage in parallel. Thats why I need these files in parallel. I need to do this for most of the jobs which have different metadata.... so I dont wa...

Can I just create a server job to write the fixed width data into another normal seq file and then get it into parallel? Will that work ?

I never used HEX, so thats gonna be a problem

I think the error is due to "Spaces between columns" value, its set to "0" in the server job when the file was created. I tried giving "0" as the "Fill Char" value in parallen seq stage, it dosent work Just curious to know,How you had done this in server job?...

Whats the best thing to do now ?

I made the change