Search found 4 matches

by fabiosantos
Fri Dec 30, 2016 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Validation Logic
Replies: 5
Views: 3081

Hi UCDI,

How to create a Data Set file? I don't have the data set file yet.
by fabiosantos
Tue Dec 27, 2016 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Validation Logic
Replies: 5
Views: 3081

File Validation Logic

Hi all, Can you please help me with the logic for the following requirement Source - Sequential File Target1 (Database) - if all rows validate as OK Target 2 (Sequential File) - if 1 or more rows validate as Non OK After read a delimited file and validated, if 1 or more rows Non OK, all rows from so...
by fabiosantos
Fri Dec 09, 2016 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Multiple Files - How to remove the "key"
Replies: 3
Views: 3279

The job is very simple: Oracle Source... ->> Transformer... ->> Sequential File Into the source, the query retrieve the emp.ID used as "key" to build the FileName. The query can retrieve several emp.ID's and can be generated more than one file in the same execution. The SF is configurated ...
by fabiosantos
Fri Dec 09, 2016 5:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Multiple Files - How to remove the "key"
Replies: 3
Views: 3279

Generate Multiple Files - How to remove the "key"

Hi,

I'm using a SF configureted to Generate Multiple Files.

I'm getting generate files name as expected, but, the "key" field cannot follow into the files.

How to remove the "key" from output file content?