Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Data Lake Storage Gen2
  3. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Configuration
  4. Microsoft Azure Data Lake Storage Gen2 Connections
  5. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Data Objects
  6. Microsoft Azure Data Lake Storage Gen2 Mappings
  7. Appendix A: Microsoft Azure Data Lake Storage Gen2 Datatype Reference

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

Microsoft Azure Data Lake Storage Gen2 Dynamic Mapping Example

Microsoft Azure Data Lake Storage Gen2
Dynamic Mapping Example

Your organization has a large amount of data that keeps changing. Your organization needs to incorporate all the updated data in a short span of time. Create a dynamic mapping, where you can refresh the source schema dynamically to fetch the updated data. Add all the dynamic ports to the target to override the metadata of the existing ports.
  1. Import the
    Microsoft Azure Data Lake Storage Gen2
    read and write data objects.
  2. Select a project or folder in the
    Object Explorer
    view.
  3. Click
    File
    New
    Mapping
    .
    The
    Mapping
    dialog box appears.
  4. Enter the name of the mapping in the
    Name
    field.
  5. Click
    Finish
    .
  6. Drag the data object into a mapping.
    The
    Microsoft Azure Data Lake Storage Gen2 Data Object Access
    dialog box appears.
  7. Select the
    Read
    option and click
    OK
    .
  8. In the
    Data Object
    tab, select the
    At runtime, get data object columns from data source
    check box.
  9. Drag the data object into a mapping.
    The
    Microsoft Azure Data Lake Storage Gen2 Data Object Acess
    dialog box appears.
  10. Select the
    Write
    option and click
    OK
    .
  11. In the
    Ports
    tab, select the value of the
    Columns defined by
    as
    Mapping Flow
    .
  12. Select all the source incoming ports and add the ports to the target.
  13. Save and run the mapping.

0 COMMENTS

We’d like to hear from you!