About nested datasets
Using SQL to extract data from 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
Denormalizing nested dataset (extracting dimensions)
Normalizing nested dataset into multiple database tables or flat files
The Destination is a nested dataset
The Source is a nested XML
The source is an XML with repeating segments

Using SQL to extract data from nested dataset

December 18, 2018 23:39
Updated

By far, the simplest way to extract data from the nested source dataset is to use SQL.

Applying SQL transformation to the nested dataset will create a flat data object which can be mapped, for example, to the table in the relational database.

Read how to extract data from a nested source dataset using SQL.

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles