Every Chronicles data point is addressed by the combination of its master file, identified by a three-letter INI, and its item number. The Data Dictionary indexes Clarity columns by this Chronicles Info, so supplying the INI and item number, for example I EPT 10110, is sufficient to retrieve the table and column that extract the item. No further information is required to perform the lookup. Add type and response type describe how the item behaves and are valuable for predicting the primary key shape and the grain of the destination table, but they cannot locate the item, since many items share the same combination of properties. The primary key of the table is an output of the research and not an input; it is learned after the table has been found. The networked INI is relevant only for items that point to another master file and, even then, identifies the related record type rather than the item itself. Understanding this minimal identifier is the foundation of Chronicles to Clarity research. After the table and column are identified, the add type and response type become useful for validating that the table ' s primary key corresponds to the expected structure and for writing correct joins.
[Reference: Cogito Fundamentals – Chronicles Data Structures: INI and Item Number; Data Dictionary, ===============, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit