The only difference between relational data and hierarchical data is one new datatype: schema. A column can not only be of type number, character etc, it can also be an entire table (schema).
Attached ATL for DI 11.5 contains DF_Master_Detail, and the datastores DWH_DS, source_ds
Attachment
ATL (ZIP 5.96 KB)
- What is it good for
- Master-Detail Table to NRDM
- An additional Hierarchy Level
- Unnest or NRDM join
- One table to NRDM
- Separating a NRDM node
- Building an XML String
- Memory requirements of NRDM
- Loading nested data in batches
- Loading nested data in batches via XML_Map