REPLACE INTO (INSERT)

[GANESA KUMAR]

Hi Team,

I have written data integration stored procedure.
There I have used REPLACE INTO (INSERT) STATEMENT .
(Assumed all the target table is having UNIQUE KEY)

Since all my target table is FACT kind of table , I won't have any primary key, only I can create composite unique key.

But new case has come, One target table has been created with 20 columns. Here is the problem come into picture . I could not create UNIQUE KEY for more than 16 columns (Composite UNIQUE KEY).

Now how can i handle this situation?

I don't want to write separate delete and insert .


Please advice for my cases and let me know if need more information.