Working with nested datasets
- About nested datasets
- Use SQL to extract data from nested dataset
- Create staging tables or flat files for each dimension of the nested dataset
- Mapping when the Source is a nested dataset
- The Source is a nested dataset and the Destination is a flat file or a database table
- Denormalize nested dataset (extracting dimensions)
- The Destination is a nested dataset
- The Source is a nested XML
- The source is an XML with repeating segments