12-17-2014 03:48 AM
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
12-17-2014 04:05 AM
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...
12-17-2014 07:47 AM
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.
12-17-2014 05:43 AM
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