Page 1 of 1

Modify Stage Problem

Posted: Wed May 30, 2007 12:40 am
by Sreedhar
When I am running a sample job where in which I have a Flat file-> Modify Stage -> Flat file

With the modify stage I am dropping a column.


The job is running successfully with out any warnings, but the outlink shows 0 records, the out put file has got the data in it

It is only misleading in the job that the No of records going out for the out or zero.

What is the work around for this. Did any one of you had this problem before.

Posted: Wed May 30, 2007 1:02 am
by ArndW
Is the problem that no records are going out of the modify stage or that the output file has records in it when none are written by the job? How many rows are being read by the job? Do you have "append" set to the target sequential file?

Posted: Wed May 30, 2007 1:45 am
by JoshGeorge
Modify stage will not report a row count to the Designer canvas in such scenarios

Posted: Wed May 30, 2007 3:28 am
by Sreedhar
Thanks for your inputs

Firstly to answer ArndW

The job is running successfully, with out any problem. My only concern is that the Data Stage Designer canvas is misleading. It shows 0 records are loaded into the output data set(file).

Secondly : JoshGeorge: Is the a limitation to the tool, do we have any workaround to populate the link results.