DSXchange

Hi, When i am reading file from source i am getting bellow error.. My souce file has 13KB(32,000 records) only,delimiter is '|'. For testing purpose i have taken 10 rows it is working fine,when i have given total file the bellow error is coming. Let me know why i am getting this error? ##E IIS-DSEE-...

Hi Chulett, Filename is a standalone parameter(in my example file is SDP101.00011)daily the filename will be change(means date or month and records also). Ex:today file is=201304040048.SDP101.00011.7190054 tomorrow file is like=201304050048.SDP101.00011.8040073 In the above example date has been cha...

I have not yet work on script and routines.Can any one help me how to write script or routines about this senario?

Hi, I have one file:201304040048.SDP101.00011.7190054(Today file) tomorrow may be i will get same file like 201304050048.SDP101.00011.8040073 and dayafter tomorrow i will get like 201304060048.SDP101.00011.8140813.... In the above example 2013(Year),04(month),04(day),0048( time),SDP101.00011(Filenam...

Hi priyadarshikunal,Ray, Yes, Ray is correct I am trying to expand data and extract that data from source. I am using 32 bit windows operating system and datastage 8.5. I am getting file from Client in zip format like (test.gz). After unzip The file the size is 4.5GB. But, as per my requirment i don...

Hi, I have a requirement where in need of unzip the files using Unix/through datastage execute command or before or after subroutines . For example my file name is test.gz I have 271,339 KB of zipped data.I have tried to unzip that data manually,after unzip the file size is 4.5GB(I have done manuall...

Hi Prasson, Thanks for ur reply.It is working fine. But,From Transformer to Transformer Stage i am getting 31000 records per second. From Sequential File to Transformer I am getting 1500 records per second only .Atleast i need to reach 10000 records per second. I have used 4 Node configuration , i u...

Hi crystal, i am getting below error.. Sequential_File_0,0: Error reading on import. Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter; aborting Sequential_File_0,0: Import error at record 0. Sequential_File_0,0: The runLocally() of the operator failed. But,Tail comm...

Hi, I have 4GB Source data,i splitted 2GB,2GB By using like this my filename is CALL_HISTORY_DETAILS.txt c:/NRD> du -sh CALL_HIST_DETAILS.txt---->(It contains the file size(4GB)) c:/NRD>wc -l CALL_HIST_DETAILS.txt------->total count is 9868002 C:/NRD>head -4934001 CALL_HIST_DETAILS.txt > test.txt C:...

Hi Chulett,

My source is sequential file.I have to read 4GB zip data from source.i am able to read 2GB of zip data.but, i am unable to read morethan 4GB zip data.
Could you please help me how to read morethan 4GB zip data from source?

Thanks for your Reply... But, I have tried before job subroutine, Filter command in sequential file and command activity. These are supporting only below 2GB of data. It is not supporting 4GB.When I tried to 4GB of data job is aborted. Error is : Sequential_File_0,0: Consumed more than 100,000 bytes...

Hi,
I have one requirment, I need to read zip file from source sequential file.My data size is more than 4GB.

Could you please help me how to read zip file?

Hi, I Have Source file Like, I/P ----- custname,custno KIRAN,[323~96.949900~7.210000][384~120.000000~0.000000][443~0.000000~0.000000][463~0.000000~0.000000][763~0.000000~0.000000][783~0.000000~0.000000][704~0.000000~0.000000] i have morethan more than 100 arrays. I want output like o/p ---- custname...