Skip to Content
avatar image
Former Member

Teradata doesn't accept duplicate rows in target template tables

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2016 at 03:25 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded