Contains information/attributes about customers, which you’re using for analysis of transactions or customers in a Datamart.
In most scenarios, you will copy the data from Customer Master into this datasource, so you also need to keep the fields in sync.
Nevertheless, the number of customers in this table could be different, than the amount of records in customer master, because in analysis you’re keeping data about customers to who you sold some goods several years back, whereas in customer master you need only active customer, to whom you’re selling right now.
Fields
the list of fields in Customer data source is different in each project, so we will show here default columns, which you can see on new partition, where it will be in sync to the default customer master table.
customerId – id of the customer
name – name of the customer, as it’s used on printed documents
parentId – copy of parentId column from customer master.
isParent – if this customer is the actual sold-to customer, or some higher level in the customer hierarchy