Search found 34 matches

by yugee
Mon Mar 03, 2014 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture Only Not matching rows
Replies: 4
Views: 1895

Capture Only Not matching rows

Hi, I have an input with a key and another table with error records. I have to match my input with the table and get only the non matching records. Currently I have a lookup, output and reject. But, since I don't want any matched records for further processing, I want to avoid writing these matched ...
by yugee
Wed Feb 05, 2014 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with FTP Multiple Files in DataStage
Replies: 6
Views: 3883

I thought of creating a FTP script with all the input files and corresponding output files. and execute this script out of DataStage.

Other than that, is there any way I can use FTP Enterprise stage with column names as variables in the input and putput file names..
by yugee
Wed Feb 05, 2014 2:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with FTP Multiple Files in DataStage
Replies: 6
Views: 3883

in my current environment, sequencers are not allowed. is there any way to achieve this in datastage job?
by yugee
Wed Feb 05, 2014 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with FTP Multiple Files in DataStage
Replies: 6
Views: 3883

Help with FTP Multiple Files in DataStage

Hi, I have a below requirement in one of my integration. > Input is a file with File name and Folder name. It has multiple records. > I have to read each record in this file and connect to a source system, get the file based on the folder and file name and place it to the target. > the file is in Bi...