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

SAS DI

Reply
Contributor kds
Contributor
Posts: 31

SAS DI

Hi Experts,

In DI Studio job, When I delete a stage in the process flow, then the mappings defined in the previous stages are broken.

Example  ::             Source(s)  -> Stage B -> Stage C -> Stage D -> Stage E -> Target table           

If I delete/drop stage E and replace it with some other stage, then the mappings of C,D get broken.....

Is there any way/logic/trick  by which I can drop a stage in the process flow and have the mappings intact in the other stages...
Thanks for any help!

Super User
Posts: 5,441

Re: SAS DI

Sounds strange. What version are you using?

Can you give examples of which transformations this happens?

In you example, removing E (Table Loader or equivalent), mappings between C and D should be intact.

What exactly is happening, do you lose the target columns of D, or just the mappings (1-1, expressions) between C and D?

Data never sleeps
Contributor kds
Contributor
Posts: 31

Re: SAS DI

LinusH , You are right.. I tried again and the mapping is still there...  Not sure , first time how mappings disappeared....


Also another thing, in Process Designer, we have tabs -> Process Editor and Source Editor

After doing some changes in Process Editor , when Source Editor is selected...     the code gets generated automatically in the source editor.... 

suppose if I want make changes directly(add one or two lines of code logic) in Source Editor, will that be possible...   or source editor only displays code as per process editor?

Thanks for your help!

Super User
Posts: 5,441

Re: SAS DI

It is possible, but absolutely NOT best practice. As soon as you edit the source code, everything in the metadata that you have defined will have no effect on the code.

So, if you want add some code, do it in pre/post code to the job/transformations.

If you want to change the, that's a different story, and needs separate discussions on each occasion I believe... Do you have any special changes in mind?

Data never sleeps
Contributor
Posts: 41

Re: SAS DI

I have seen that happen as well.

But that was in 9.2, and I think that at some point (TS2?) this was fixed.

I does not occur (at least not that often) in 9.3 (which is now at DIS 4.6).

Ask a Question
Discussion stats
  • 4 replies
  • 385 views
  • 0 likes
  • 3 in conversation