Dynamic Transformer selection

More
11 years 2 months ago #5333 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.

More
11 years 2 months ago #5334 by CodeGnome
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.

More
11 years 2 months ago #5335 by admin
You may include package into the package (so it is a container to some extent)

Peter

Mike
ETL Architect

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

More
11 years 2 months ago - 11 years 2 months ago #5336 by CodeGnome
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
Attachments:
Last edit: 11 years 2 months ago by CodeGnome.

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

More
11 years 2 months ago #5339 by admin
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

Mike
ETL Architect

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

More
11 years 2 months ago #5342 by CodeGnome
Generic for maximum benefit is my thought exactly.

Thanks for considering it.

Marshall

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