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

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

ReinLemmens — Wed, 17 Dec 2014 08:48:40 GMT

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

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

LinusH — Wed, 17 Dec 2014 09:05:42 GMT

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...

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

Patrick — Wed, 17 Dec 2014 10:43:44 GMT

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

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

ReinLemmens — Wed, 17 Dec 2014 10:46:50 GMT

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

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

ReinLemmens — Wed, 17 Dec 2014 12:47:58 GMT

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.