Understanding Data Lineage

Data lineage is the process of tracing where your data comes from and how it changes throughout its whole lifecycle within a system or across several. In the context of data transfers from NetSuite to the Analytics Warehouse, it refers to the process of understanding and documenting how data moves from NetSuite to the Analytics Warehouse platform, so you always have a clear and traceable path for analysis and reporting.

NetSuite Analytics Warehouse Data Lineage Mapping Guide

Data lineage helps analysts and business users see where data comes from and how it changes, making it easier to understand and use the fields effectively in the Analytics Warehouse.

To get a better look at how data moves from NetSuite to the Analytics Warehouse, download the Data_Lineage_NS_NSAW mapping guide.

This mapping guide has eight columns that show how data moves through three key stages:

NetSuite: this is the initial stage. It shows the original structure of your data in NetSuite, and it is represented by the columns under the NetSuite Linage section.
Data Warehouse: this is the middle stage. It shows how your data is stored in NetSuite Analytics Warehouse. It is represented by the Physical Table and Physical Column columns under the Semantic Model (RPD) Lineage section.
Analytics: this is the final stage. It shows the semantic layer of the data as it appears in the Analytics Warehouse, specifically designed to make reporting and analysis easier. It is represented by the Subject Area, Table (Analytics), and Column (Analytics) columns.

The table below explains what each column in the mapping guide means:

NetSuite Lineage	Semantic Model (RPD) Lineage
NetSuite Table	NetSuite Column	NetSuite Table Type	Physical Table	Physical Column	Subject Area	Table (Analytics)	Column (Analytics)
This column shows the name of the table in NetSuite where the data comes from, for example Account.	This column lists the name of the specific data field in the NetSuite table, for example displaynamewithhierarchy.	This column defines the type of table in NetSuite, for example Other Record.	This column shows the name of the table in the Analytics Warehouse where the data is stored after transfer, for example DW_NS_ACCOUNT_D. Note: This name may be different from the NetSuite table name due to data warehousing conventions.	This shows indicates the name of the data field in the data warehouse table, for example DISPLAYNAMEWITHHIERARCHY. Note: This name may be different from the NetSuite column name due to data warehousing conventions.	This column shows the subject areas within a functional area in the Analytics Warehouse. Subject areas group related data to help you find what you need. For example, NetSuite -Assembly Build.	This column shows the table name as it appears in the analytics tools. These tables are set up to make reporting easier. For example, Item.	This column lists the data field name as it appears in the Analytics Warehouse. These names are meant to be more descriptive and intuitive. For example, Item Income Account.

NetSuite Lineage

Semantic Model (RPD) Lineage

NetSuite Table

NetSuite Column

NetSuite Table Type

Physical Table

Physical Column

Subject Area

Table (Analytics)

Column (Analytics)

This column shows the name of the table in NetSuite where the data comes from, for example Account.

This column lists the name of the specific data field in the NetSuite table, for example displaynamewithhierarchy.

This column defines the type of table in NetSuite, for example Other Record.

This column shows the name of the table in the Analytics Warehouse where the data is stored after transfer, for example DW_NS_ACCOUNT_D.

Note:

This name may be different from the NetSuite table name due to data warehousing conventions.

This shows indicates the name of the data field in the data warehouse table, for example DISPLAYNAMEWITHHIERARCHY.

Note:

This name may be different from the NetSuite column name due to data warehousing conventions.

This column shows the subject areas within a functional area in the Analytics Warehouse. Subject areas group related data to help you find what you need. For example, NetSuite -Assembly Build.

This column shows the table name as it appears in the analytics tools. These tables are set up to make reporting easier. For example, Item.

This column lists the data field name as it appears in the Analytics Warehouse. These names are meant to be more descriptive and intuitive. For example, Item Income Account.

NetSuite Analytics Warehouse Data Lineage Mapping Guide

Related Topics