Modify Stage Problem

Sreedhar · Post by **Sreedhar** » Wed May 30, 2007 12:40 am

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.

ArndW · Post by **ArndW** » Wed May 30, 2007 1:02 am

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?

JoshGeorge · Post by **JoshGeorge** » Wed May 30, 2007 1:45 am

Modify stage will not report a row count to the Designer canvas in such scenarios

Sreedhar · Post by **Sreedhar** » Wed May 30, 2007 3:28 am

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.