DSXchange

Hi All,

I have to convert the negative numbers into positive value with braces [()].

Eg:1

Input Output
-13.90 <13.90>

Eg2:

Input Output
<-13.90> (13.90)

Please let me know you thoughts on this.


Thanks,
Satheesh

Hi All, We have the below issue while loading the data to target table using Bulk load stage LoadEDWSale..TgtEDWSaleOra: DATEFORMAT='YYYY-MM-DD'. LoadEDWSale..TgtEDWSaleOra: TIMEFORMAT='hh24:mi:ss'. LoadEDWSale..TgtEDWSaleOra: MAXRECORDNUM='10000'. LoadEDWSale..TgtEDWSaleOra: LOADMODE='Automatic'. L...

Hi All, I have a requirement to create the hashed file with FileName and RecordCount. FileName as key column. If the source stage doesn't return any rows the hashedfile needs to create with the records as Filename and recordcount as 0. If the soure stage return any rows it would create the Filename ...

Hi Friends, Today i just got the below errors in one of my jobs(Fixed-width sequential file). column unexpectedly ended by EOR All i need to do is just need to reject that particular row and create the bad records and process the remaining correct records. Please let me know how to capture the ended...

Hi Chullet,

It is an account based hashed file.


Thanks,
Satheesh

Hi All, Is there any way to Move the Hashed file from one project to another project. We have a requirement to create a hashed file in one of the environment.So i just created the file.But the actual job that uses the hashed file is in another project. If i want to re-create the hashed file in the s...

Hi,

Thanks for your feedback on this. We made a decision to overwrite the file everyday irrespective of number of records.


Thanks,
Satheesh

Hi All,

We have a requirement to Create sequential file only if any rows written into it, otherwise no need to create a sequential file.

please let me know you thoughts on how to acheive this task.


Thanks,
Satheesh

Hi All,

We have a set of hashed files, we will need to identify which hashed files is used by the job.

The reason is we have around 2000 jobs.So we need to find out which job uses the corresponding hashed file as a lookup.


Please let me know your thoughts.


Thanks,
Satheesh.

Hi Chulett,

I have identified the issue with the FTP job.we have an DS FTP job.The filename parameter in the job sequences had a space at the end of the file name. probably a cut and paste error. I removed the space and it works fine.

Once again thanks for your suggestions.



Regards,
Satheesh

Great Thanks. Chulett.



Satheesh.

Hi Chulett,

Exactly, Thanks for the heads-up.

dstage/appl/inbox/Misc>more rew.Flat_Fee_LocationExclusionList.csv*
17426
21814

Can you suggest me on how to access these files.



Thanks,
satheesh

Yes, I belongs to dstage user. No permission issue. we could see the file is present physically. /dstage/appl/inbox/Misc>ll total 4 -rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_CDC_Codes.csv -rw-rw-r-- 1 srajan02 dstage 12 Aug 10 21:04 rew.Flat_Fee_LocationExclusionList.csv But we we tr...

Hi ArndW, /dstage/appl/inbox/Misc>ll total 4 -rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_CDC_Codes.csv -rw-rw-r-- 1 srajan02 dstage 12 Aug 10 21:04 rew.Flat_Fee_LocationExclusionList.csv /dstage/appl/inbox/Misc>ls -ltr total 4 -rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_C...

Hi, Today we have a strange problem while accessing a file. We have Ftp'ed a file from 3rd party system and place it into inbox folder.The we have a job to move the corresponding file into staging folder and backup the file into archive folder for future reference. Once the Ftp job gets completed,th...