DSXchange

Yes, as mentioned in my above post, 3rd column delimiters might get vary, since now we have a,b,c,d but next record might be a,b,c,d,e,f. so column no will get increase at that time. this all needs to happen at run time.

Regards,
Manju

Hi, I have come across with RARE kind of requirements which i have work till now. Source is sequential file (pipe delimited) Data look like abc|xyz|a,b,c,d|123 but i need to produce the file with 7 columns for above record. like this. abc|xyz|a|b|c|d|123 Here one more thing is 3rd column in the abov...

Sir,

I am working with Paraller job transformer. Is there any alernate way please.

Hi I need to add thousand separator to the digits which i am getting from source
for ex: source data : 20582255100
target should be : 20,582,255,100

can you suggest the solution

Thanks. I am searching ...

Hi Friends, I have requirement like below Col1 Col2 A Chennai A Bangalore A Dehli A Jaipur A Sydney A hongkong But i need the result like below. Col1 Col2 Col3 Col4 Col5 Col6 Col7 A Chennai Bangalore Dehli Jaipur Sydney hongkong Can you please help me how to do this? i am using 8.1 version. Thanks. ...

Hi,

Please help me out to convert the decimal values to decimal value.

My source : teradata
target: file

source showing the records as 8194.00000000 (decimal(24,8 )
Target its showing as 000000000008194.00 (decimal(17,2)


But i need to remove the leading zeros.

Thanks Sir,

Please let me know the logic to convert the decimal values to Hexadecimal in parallel extender 8.01 version.

Since I dint find any functions available in PX.

Hi, please assist the below column mappings. "Move ACCT_N. Format as a 7 byte packed decimal. E.g. '0216589675492' would be HEX '0216589675492F'. " ACCT-N Set to HEX '045F' TRAN-C "Move PERS_BRTH_D. Format 'CCYYMMDD'. Format as a 5 byte packed decimal. E.g. '25 June 1948' would be HEX...

Thanks , target column is char 1(Filler)

Hi,

The mapping given for the source to target mapping sheet is as follows.

set HEX '25' to colA

How to convert to HEX in Parallel extender 8.01


Appreciation for your help.

Thanks,
Manj

Sequence Job parameter has high priority than the job parameter called in the sequence.