DSXchange

Directory to be accessed has already been granted with 777 and owner of directory is same name as the credential ID. Jobs can still continue to run.

Yes, is there a way to do insert, update & delete all in a single job?

It is a transaction refresh to Oracle stage. We did not use truncate nor replace as there is both new & amended records.

It is a transaction refresh to Oracle stage. We cannot do truncate nor replace as there is both new and amended records.

Is there any way to delete existing record before insert into the database in a single job? There is a delete before insert in version 7, however I no longer see it in version 8. The work-around I am doing now is to have a job to read from source and delete from target, and then another job to read ...

Requirement: To delete existing record in table before insert, based on a sequential file. Version 7.2 used to have an option to delete existing records before insert but I don't see it in version 8. Problem: Parallel job batch up the delete and insert of records. Eg. The file have 500 records, it d...

Actually, I just got a very roundabout way to get what I want. Sample Main Data: ID CODE 1 A 1 * 1 B 1 C 2 D 3 * 3 # Result: ID FINDING 1 * Found 2 NIL 3 * and # found Method: 1) Based on the file, get a distinct list of ID that contain * and another list for #. 2) Using the main data, do a lookup t...

Requirement: 1) Run unix shell script via Execute Command to get text file's data for downstream processing. 2) The directory of the unix script will be based on the value in parameter set due to UAT & PRD environment. 3) Value retrieve will be used to read another file or to use it as a where c...

Requirement: 1) For record of the same ID, check that if CODE only contains * then derive as '1' and if contains both * & # then derive as '2'. 2) There is no fixed number of occurances for the same ID. Restriction: We do not have pivot installed. Sample Data: ID CODE 1 A 1 * 1 B 1 C 2 D 3 * 3 #...

Thanks, got it to work using 1st mtd. Will try the method to globalise it.

Requirement: 1) Pass multiple parameters from flat file to parallel job. 2) Parameters to be used globally by other jobs. Flat File's Content:- FILE_NAME=abc.txt START_DATE=20080526 END_DATE=20080531 Currently, I managed to use a Execute Command to pass a SINGLE parameter to a Job Activity. However,...