Hi,
I have one table in SQL where data coming from source oracle.
Itmkey is not there in source and it have identity constraint
CREATE TABLE [dbo].[Itm](
[ItmKey] [int] IDENTITY(1,1) NOT NULL,
[CustId] [int] NOT NULL,
[CustNm] [nvarchar](100) NOT NULL,
[PartNm] [nvarchar](100) NOT NULL,
[ItmId] [nvarchar](100) NOT NULL,
[ItmTyp] [nvarchar](50) NOT NULL
)
GO
Below are the index created on the table
CREATE UNIQUE NONCLUSTERED INDEX [XAK1Itm] ON [dbo].[Itm]
(
[CustId] ASC,
[PartNm] ASC,
[ItmId] ASC,
[ItmTyp] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
my requirement is that I have to truncate and load every time when my package run.
kindly find the attachment of above table data. I don't understand how ITMKey are generating uniquely.
kindly help me to understand the above concern