SCD stage -- output link

[edwds]

Is it Mandatory to have an Output link from the SCD stage in the ETL job when using a SCD stage.

I am using a SCD stage in my job to load the Dimension table. I don't want the output sent to a file.

If I just use one link to the Dimension table and NO output links, it gives the following error:

The required output link for the SCD stage 'SCD' was not found!

[JRodriguez]

It's mandatory ... that's the nature of the beast ...

Is it Mandatory to have an Output link from the SCD stage in the ETL job when using a SCD stage.

I am using a SCD stage in my job to load the Dimension table. I don't want the output sent to a file.

If I just use one link to the Dimension table and NO output links, it gives the following error:

The required output link for the SCD stage 'SCD' was not found!

[ray.wurlod]

... but you can direct it to a Sequential File stage that appends to /dev/null if you wish to discard the records.

[vmcburney]

I send the fact output to a copy link that goes nowhere and reduce that output to just one column for speed.

[Raftsman]

Would it not be more efficient to sent the SCD Output link to a Peek other that a copy. Would the copy not chew up resources?

Thanks

[ray.wurlod]

A Copy stage with no output links serves as a sink and consumes no (or negligible) resources. Look at the score for the job.