I want to create a generic transformation that I can run for several data sources.
For example, I have some files to load in a database in the same way.
Is it possible to create one transformation that can take different file formats and run the load? I am able to pass database name, table name and other connection information as variables but cannot figure out how I can pass the file layout.
Any help will be appreciated