Working with nested datasets

Working with nested datasets

• About nested datasets
• Mapping when the Source is a nested dataset
• Use SQL to extract data from a nested dataset
• Create staging tables or flat files for each dimension of the nested dataset
• Flatten nested dataset using Extract Dimensions transformation
• Transform nested XML using XSLT