Add To Library Feature Request

More
1 year 11 months ago - 1 year 11 months ago #21124 by bruce.gibbins
Hi

I would like to offer another feature suggestion which is based on our drive to make certain scenarios reusable or at least to allow the Object Library to store reusable components.

I believe that this facility could be greatly enhanced if it was possible to store a set of linked objects and not just a single object.

For example in the attached screenshot I am using a literal in an SQL Lookup to locate an associated Entity ID value from the database. If I select all of the linked objects and Add To Library, then only the SQL Lookup component is stored.

Ignoring the fact that SQL lookups are slow and we could (and do) do this through stored procedures down stream in the associated package it does sometimes make development easier if we could just do the lookup in the transformation when performance is not an issue.

Therefore, if we could just add the basic action object template into the transformation and then rework the input parameters accordingly, it would save having to reenter all of the inputs and outputs again.

Thanks for your consideration

Attachments:
Last edit: 1 year 11 months ago by bruce.gibbins.

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21126 by Peter.Jonson
Hi Bruce

Thank you for your feedback.
There is a batter option available already.
It is called sub-transformations.
They were created to be reusable and can be added to the objects library.


Peter Jonson
ETL Developer
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21132 by bruce.gibbins
Thanks. I didn't notice these existed.

Appreciate it. They will come in very handy

Cheers

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21136 by admin
Also not sure if you are aware that it is possible to create tabs within the transformation.
You may find it useful for complex transformation.


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago - 1 year 11 months ago #21137 by bruce.gibbins
Thanks. Yes I use these quite a lot and it is what drove my feature request for a dedicated documentation tab in Packages and Transformations.
Last edit: 1 year 11 months ago by bruce.gibbins.

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21138 by bruce.gibbins
Thanks. Yes I use these quite a lot and it is what drove my feature requwstbforna dedicated documentation tab in Packages and Transformations.

Please Log in or Create an account to join the conversation.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.