DSXchange

I'm trying to create a file with header records, detail records, and trailer records. I'm pulling all the data from one table, then I need to sort by a given field, then for each record with matching values in that field, I need to write a header record, all the datail records, then a trailer record...

I have a DataStage server set up on an AIX machine, and when I schedule a job, I typically get something such as the following in the crontab: /u009/etl/Ascential/DataStage/Projects/Eclipse/dsr_sched.sh /u009/etl/Ascential/DataStage/Projects/Eclipse /u009/etl/Ascential/DataStage/DSEngine ImportRejec...

I need to create a flat file from 2 Oracle tables. The Oracle tables have a parent/child relationship and the flat file needs to reflect this relationship in the following format: Parent Record 1 child record 1a child record 1b child record 1c Parent Record 2 child record 2a child record 2b etc...et...

I need to load a file into an Oracle table. This file can have hundreds of records but they are all on the same line in the text file. In other words, there are no line breaks in this file. The record length is 2024 spaces and somehow I just need to tell DS to start back at the beginning of the reco...