DSXchange

Hi Mathieu,


I gave in stage properties stage variable totprcval sql type as bigint . I got my output with out any exponentional value . Thanks for solving my problem.





Thanks,
Somaraju

Hi Mathieu,

Please correct me if I understood your reply wrong. I have to give in stage variable properties totalprcval precision as int 64 and in expression of stage variable in place of As integer I have to give string to decimal function.




Thanks,
Somaraju

Hi Williams,



Thanks for solving my problem.




Thanks,
Somaraju

Hi, Can any one help me. I have a stage variable totalpriceval. In properties of stagevariable I mentioned precision as varchar 255 . Iam getting frm source flat file price as char[15] to stage variable . Ex variable expression totalprcval If frm_src.recindicator='2' then totalprcval+As integer (frm...

Hi , Iam capturing duplicate records with sort stage Keychange columm. To achieve this Iam using two duplicate stages one for sorting records on key1,key2,key3 and key4(price) and another sort stage is for keychange columm. Actually my requirement is to find duplicate for key1,key2 and key3 and I ha...

Hi Ram, My actual requirement is I want to write number of records and total price value of all records to a output from transformer stage. when Iam writing to a Dataset from a transformer then Iam getting count for each and every record. I want total count (total number of records and total price v...

Hi Ray, Iam not using Hash file for Lookup. Actually I want to use Hash file Stage in PX ,so that I can write output from two transformers in PX to the Hash file. Iam having only Hash file with out any links in server SharedContainer so I couldnot validate the links. Please correct me if Iam wrong. ...

Hi, I want to use Hash File in Px . I constructed server shared Container with Hash File in it . Iam connecting two input links from two transformers to Server Shared Containeer. When Iam opening a Hash File inside Server Shared Container I couldnot find any input page in hash file and I can see onl...

Hi Ray,


Iam a poor consultant. I can't pay you or IBM. Any how thanks for the forum for being so help full in solving my other problems in PX.


Thanks,
Somaraju.

Hi Ray,


Can you tell me in detail what to search in google and also can you tell me what I have to do in parallel routine to achieve CRC32 function


Thanks,
Somaraju

Hi, I want to know wether there is a function called CRC32 available in PX. I have a requirement like this in stage variable in transformer I have to calculate duplicate records with CRC32 and I have to assaign to other variable TotRejRec = If Dupcheck = 'Y' Then TotalRejRec+1 Else TotRejRec. In fun...

Hi Williams,

Thanks for your help . I set clear the partition in remove duplicate stage before the surrogate key stage and it worked.



Thanks,
Somaraju

Hi Rasi, Thanks for reply . I know that Dataset Stage can have only one input link and Iam asking is there any stage in Px that can have two inputlinks. My requirement is like this I have two transformers with stage variables and I have to output from those two transformers to a file (in server iam ...

Hi, Is there any stage (filestages) in parallel extender like hash file stage in server where we can have any number of inputs or output links. I want to write to a file (same file ) from two transformers. In server job Iam writing to the same hash file from two different transformers. If there is n...

Hi Kumar, I tried your option . I gave hash partition in sortstage and and set perserve partitioning to default and I gave the same hash partition to the remove duplicate stage and set perseved partition to default. I got a warning message saying Rmv_VFD_Cbl.Frm_Sort_cbl_Sort: When checking operator...