DSXchange

Hi, I have a requirement to load three target tables which have parent and child relationship. I tried loading these three tables in a single job. The parent table got loaded and job got aborted due to referential integertity constraint in child tables. Though i have ordered the output link using &q...

Hi, I have a requirement to fetch two files from FTP server and then to perform checksum operation on those files. Need to identify those files are identical or different using the checksum value. I can perform column or record level checksum using Basic transformer. But no clue of how to do this co...

Hi,

Can anyone please tell me is there any possibility to download ZIP file from FTP server. I succeeded downloading a stand alone file (csv) from FTP server. Need to know any option available to download ZIP file.

Regards,
Raja

Hope the Metadata of the hashed file might be changed and the changes is not reflected in the file that is created. It means the Hashed file will have the old metadata structure. Delete both the Hashed files and run the job as a fresh one.

To prevent the execution of jobs that don't have data in its source file, you need to check the data availability of each input file using the shell script and call it will the help of Execute Command. But i feel you need to incorporate this before all the 100 Job activities that are available. My s...

ray.wurlod wrote:What do you want to replace them with? Use a Convert() function. ...

Use the below code to remove the pipeline symbol

Convert('|','',<FieldName>)

Check the things that Arnd specified and to resolve this kill the process which is running in the background. Regards, Raja Soundararajan I am running a sequence and becuase of some errors it has aborted. When i am trying to compile the jobs present in the sequence the jobs are giving compile error ...

Hope you are running in UNIX platform. If so use "rm" command with options available and place all the commands in a file. So the file will have the coding to remove all the files that are created. In Sequence you have an activity called Execute Command. Use that activity and make a call t...

In the Job activity of a2 you have a option "Unconditional". Select that option so that though if a2 is getting aborted the following job activity a3 and a4 will be triggered. Regards, Raja Soundararajan Hi All In my project there is one master sequence job say A which calling other sub-se...