DSXchange

There is no equivalent available for Teradata. May be, not required. In case of Oracle, the APT_ORACLE_PRESERVE_BLANKS variable affects the whitespace trimming. It is important in case of SQL*Loader, because Oracle removes the spaces and considers fields with only spaces to be NULL values. But with ...

One way is, write a shell script to update your Oracle table and call that script using the DSExecute() function. Pass the captured values as parameters to this call.

Check the line(record) terminator and see if switching that will help you to resolve this issue.

Looks like an interviewer's requirement.

1. Capture the duplicates into a file
2. Do a lookup on this file to remove all the records having duplicates.

You may have to split this into two jobs.

Please check if that ID has proper access permissions on the second node. And also check the correctness of the path.

Please check if that ID has proper access permissions on the second node. And also check the correctness of the path.

One way is to create a small unix script where you have to check the file size and split it using Unix "split" command into multiple files.

The details in your posting are not clear enough to suggest more than this.

Try to split the file before the FTP. I am not able to recollect, but there is a FTP command which can split and transfer the file. Do a websearch for that command and try.

Thanks Ray and Craig.

ray.wurlod wrote:Do you mean the jobs that are designed into the sequence as Job activities, or do you mean the jobs that are actually executed when the sequence runs (which may be only a subset of the first list, depending on the logic of the sequence)?

The jobs that are actually executed when the sequence runs.

I have a sequence which contains some Job Activity components along with some other activities. Now I want to know if there is a way to display the names of the jobs that are part of the sequence. Basically I want to know if there is any command or SQL to get these details. Similarly is there any wa...

Sorry. I was waiting for the renewal of my premium membership to read your message. Infact, I haven't made any changes to the job. The job is exactly the same in both the occassions. I changed only the source file. The trimming was manual. I copied 10 good records from the original file and 10 bad r...

My job design is as follows: seq file (fixed width) ----> Copy Stg ----> Shared Container ----> Copy Stg ---> .... The problem is, when I ran the above job with around 750,000 records, all the records were read through the shared container and some records got rejected inside the shared container to...

ODI, formerly Sunopsis which was acquired by Oracle, is basically an ELT tool. In the ELT approach, the data is extracted and loaded first into the DWH and then the transformed using some knowledge modules. OWB, on the other hand, is a traditional ETL tool similar to DataStage. For the architectural...

Call the DSExecute function instead of ExecDOS or whatever to call the Shell script and parse the output to read the value you need. Use some smart logic to read the value from output. To keep your script dynamic, keep the SQL in a separate file, as you are doing currently, and pass the SQL script n...