SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
New Contributor
Posts: 3

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

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

Super User
Posts: 5,424

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

Posted in reply to ReinLemmens

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

Data never sleeps
New Contributor
Posts: 3

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

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.

Respected Advisor
Posts: 4,173

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

Posted in reply to ReinLemmens

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.

Capture.PNG

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

Capture.PNG

New Contributor
Posts: 3

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

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

Ask a Question
Discussion stats
  • 4 replies
  • 330 views
  • 6 likes
  • 3 in conversation