Skip to Content
0

Teradata doesn't accept duplicate rows in target template tables

Oct 24, 2016 at 12:26 PM

39

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Aasavari Bhave
Oct 26, 2016 at 03:25 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded