- Posts: 539
- Thank you received: 59
Add To Library Feature Request
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
Less More
1 year 11 months ago - 1 year 11 months ago #21124 by bruce.gibbins
Add To Library Feature Request was created 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
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
Last edit: 1 year 11 months ago by bruce.gibbins.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
1 year 11 months ago #21126 by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Add To Library Feature Request
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.
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
Please Log in or Create an account to join the conversation.
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
Less More
- Posts: 539
- Thank you received: 59
1 year 11 months ago #21132 by bruce.gibbins
Replied by bruce.gibbins on topic Add To Library Feature Request
Thanks. I didn't notice these existed.
Appreciate it. They will come in very handy
Cheers
Appreciate it. They will come in very handy
Cheers
Please Log in or Create an account to join the conversation.
1 year 11 months ago #21136 by admin
Mike
ETL Architect
Replied by admin on topic Add To Library Feature Request
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.
You may find it useful for complex transformation.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
Less More
- Posts: 539
- Thank you received: 59
1 year 11 months ago - 1 year 11 months ago #21137 by bruce.gibbins
Replied by bruce.gibbins on topic Add To Library Feature Request
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.
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
Less More
- Posts: 539
- Thank you received: 59
1 year 11 months ago #21138 by bruce.gibbins
Replied by bruce.gibbins on topic Add To Library Feature Request
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.