How data integrator handle dynamic table name

[Former Member]

If some of the source data tables are so big that a new one will be created every month. Each table will have a suffix like u2018_yyyymmu2019.

How DI can handle these dynamic changing table names? Can we just build 1 batch job but changing these table name using parameters?

Regards,

Derek

[Former Member · Accepted solution]

Hi Ben,

The link you refer is about Job Server DI configuration which seems not related. Can you show me the correct one?

Thanks for your kind attention.

Derek

[Former Member · Accepted solution]

Hmm... looks like copy/paste URL to forum threads does not work well.

To find the post, you can just serach this forum on "variable table" (without the quotes). The first result returned is the post you need...

[werner_daehn · Accepted solution]

is the link.

I prefer using database views. Create the view in a script to point to the right table and DI reading that view.

[Former Member]

Check the thread below for two possible approaches :

1) Use a view

2) Use SQL transform