In this section, we'll go by one by one dimension and understand the metadata load process of all dimensions. To start with, we'll pick the Accounts dimension.
We had already gone through individual field/ setting of account dimension member in the previous Chapter 6, Settings, to name few of the fields, they are Alias, Data Storage, Data Type, and so on. Here, in this section, we are loading metadata that is, members of account dimension members through a flat file with the help of the utility. The flat file should also have the information of member properties such as Alias, Data storage, Data type, and so on. Hence, we not only load members of a dimension. But also load their properties
Before we can create a flat file, we should be able to understand parent-child relationship. As we know, everything in our hierarchies is going to be in relationships. As smart consulting team, we generally make a parent-child relationship before we create a flat file to load...