- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2023 05:42 AM - edited 04-19-2023 05:42 AM
Hi, I am trying to load switch data from data source. The switch is getting inserted. Now I am trying to insert the switch port information. I added two classes one is switch and other one is switch port to create contains:: contained by relationship. When I am trying to load the data it is asking me insert the native key. I kept interface number as native key as it is the ID attribute for switchport. It is not working correctly. The data have similar interface number but the CI is changing. Please help
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2023 07:43 AM
Sorry,
SNK is your Source Native Key in the IH ETL world it's your "coalesce" value. Take a look at this article and see if it helps.
You must have a unique SNK across all of your imports in order for the data to import correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2023 10:56 PM