Teradata doesn't accept duplicate rows in target template tables

[Former Member]

Hello,

I would like to know how to create a multiset table through a template table because by default it's created as a set table and I can't see where to change it.

Also, if I activate the "Distinct rows" check to not have duplicated rows in the target, it take ages to finish. What could I do?

Thanks and regards,

[aasavaribhave]

You may not be able to create a multiset table using template table, and you cannot edit a template table - it will be created based on query transform that's connected to it.

And for Teradata are you using bulk load?