DSXchange

Hi all, General Question here, something basic or obvious I'm not doing. Situation. I Have server jobs which extract from source to Sequential files. The data types vary - Varchars, Integers, Dates. I then use the Sequential file in Px stage to load into Target schema. Problem : When I try and view ...

Thanks guys. Yes used an "Execute Command" stage to call a Windows Script file which converted the file into a comma delimited string and passed that to a "User Variables" stage and into the loop. All I have to worry about now is the limitation on string length which can be proce...

Hi Ray, Can you elaborate. I'm not sure how this is going to solve the problem. I have a sequential file with a Company name per row. I need to pass the Company Name one by one from the file into the Job as a parameter and repeat this Job for the total number of Companies listed in the file. BTW, th...

Hi all, Need some advice on the best approach here. ( Business Problem explained below ) Technical Problem. I have a Unidata Job which accepts a parameter, based on the paramter extracts the correct data and Generates a file. I would like to repeat the job for each list item in a file. There are 100...