- Posts: 41
- Thank you received: 1
Dynamic Transformer selection
11 years 2 months ago #5333
by CodeGnome
Dynamic Transformer selection was created by CodeGnome
I will be receiving many files that will require different transformations. I can discriminate between transformations by File Type and User ID. I would like to build a package for each File Type and have the package determine the transformation to use based on User ID. I don't want to chain multiple transformations moving through each until a match is found. I would rather have something like a list of transformations from which the matching transformation is selected based on criteria within the list. In my example, the list would contain User IDs and the associated Transformation. I hope this makes sense.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #5334
by CodeGnome
Replied by CodeGnome on topic Re: Dynamic Transformer selection
The more I think about this, perhaps a container object would provide the most capability. The idea is basically the same, but the container would allow the use and dynamic selection of any object. I would expect to define the type of container to ensure only like objects are included. So a Transformation container would contain only Transformation objects.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #5335
by admin
Mike
ETL Architect
Replied by admin on topic Re: Dynamic Transformer selection
You may include package into the package (so it is a container to some extent)
Peter
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
11 years 2 months ago - 11 years 2 months ago #5336
by CodeGnome
Replied by CodeGnome on topic Re: Dynamic Transformer selection
That's true Peter, but not actually what I've got in mind. I've attached a quick diagram that I hope explains it a little better.
Thanks,
Marshall
Thanks,
Marshall
Attachments:
Last edit: 11 years 2 months ago by CodeGnome.
Please Log in or Create an account to join the conversation.
11 years 2 months ago #5339
by admin
Mike
ETL Architect
Replied by admin on topic Re: Dynamic Transformer selection
I see what you mean now.
I will speak with our development team about that.
We would need to make it as generic as possible so all users will benefit from it
Mike
I will speak with our development team about that.
We would need to make it as generic as possible so all users will benefit from it
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
11 years 2 months ago #5342
by CodeGnome
Replied by CodeGnome on topic Re: Dynamic Transformer selection
Generic for maximum benefit is my thought exactly.
Thanks for considering it.
Marshall
Thanks for considering it.
Marshall
Please Log in or Create an account to join the conversation.