NSAW - Connect to shipping address

Question

I want to connect the address for transactions.  I see the table DW_NS_TRANSACTIONSHIPPINGSADDRESS has the value NKEY.  What value does this relate to in order to connect to the shipaddress on the transaction table?  It looks like the same value as the Source Record ID, but when I connect by the source record ID, the data does not match.

James Mendoza-Oracle · Accepted Answer

Hi @Elizabeth Vance

In NSAW, the field NKEY is a surrogate key generated within the warehouse. It does not directly correspond to the Source Record ID from NetSuite, which is why joining on Source Record ID would not return matching results.

For tables like DW_NS_TRANSACTIONSHIPPINGADDRESS, the NKEY is intended for internal joins within NSAW, typically linking to related fact or dimension tables using warehouse-generated keys rather than source system IDs.

To properly connect shipping address data to transactions, you would usually:

* Identify the corresponding foreign key in the transaction fact table (e.g., shipping address key)
* Join using the NSAW surrogate keys (NKEY or related keys) instead of Source Record ID

For more details on NSAW data modeling and structure, you may refer to:

* Oracle Documentation (NSAW Overview & Admin Guide): https://docs.oracle.com/en/cloud/saas/netsuite-analytics-warehouse/nsawa/
* Oracle Analytics / Data Modeling Concepts (surrogate keys & warehouse modeling): https://docs.oracle.com/en/cloud/paas/analytics-cloud/

Regards