Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 15:39:19 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Converting MULTISET Table to Set Table
From:   Khan, Rehan

Well it depends. INS-SEL is anyway not a choice in this case, so you need not focus on this.

If you are sure there are no duplicate rows and only PI duplicates. You can still use Fexp || Mload. Now come the question whether you want to take your duplicate PI's into your new table or not.

For that I will need some more information of the situation and what you are trying to achieve in order to refine my reply.

Best Regards,

Rehan A. Khan, PMP
Teradata Certified Master
Teradata, A Division of NCR

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020