SAS DI studio: Insert an idempotent (dummy) transformation in te middle of an existing job

[ReinLemmens]

Hi,

newbie alert.

Whilst expanding a SAS job, I often have to insert transformations halfway a job.

Is there a way to insert a transformation between existing transformations in a job without touching the existing column mappings, join conditions etc?

I'm using DI studio 9.4 en SAS 4.7

Thanks,

Rein

[LinusH]

What do you mean by "not touching"? What is the behaviour you wish to avoid?

But I think I understand what you mean, it's hard to change a flow with all intact mappings.

By adding the new transform, the move the existing connectors works best. But for some transformations nothing helps...

[ReinLemmens]

Thank you very much.

What I want to do is for instance insert an extract transformation between 2 existing transformations, just to throw out some irrelevant lines.  Without having an impact on the transformations that follow.

[Patrick]

If you need to break a flow then you will be loosing mappings. There is sometimes no way around it.

You can reduce the impact by turning off "Include in Propagation" and "Include In Mappings" for all affected transformations BEFORE you break the flow to insert a new transformation.

I "hate" these two options that much that I normally turn them off generally under Tools/Options/Job Editor

[ReinLemmens]

Thank you very much, that's indeed already a start.