no records getting loaded in target

[vikind]

SQL State: 23000 Native Error: 547
State: 1 Severity: 16
SQL Server Message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_CLAIM_RECEIVED'. The conflict occurred in database 'HPXRCareKey', table 'DATEDIM', column 'DATEKEY'.


SQL State: 01000 Native Error: 3621
State: 1 Severity: 0
SQL Server Message: The statement has been terminated.

SQL State: 23000 Native Error: 515
State: 2 Severity: 16
SQL Server Message: Cannot insert the value NULL into column 'DISCHDATEKEY', table 'HPXRCareKey.HPXRCareKey.CLAIMFACT'; column does not allow nulls. INSERT fails.

 

[Sridharan]

Vik,

Its basically due to some FK and PK Violations... In the first one the Key that you are inserting doesn;t have the necessary value in the Parent Table... Looks like you are inserting a Surrogate Date Key... Check the Mapping or maybe Debug the Mapping and check the Value that is being Looked Up... In the Second one you are trying to insert a NULL value into a Non Null Column PK...


Sri