SQL code for selecting source column names and target column names that are mapped and writing into a log file

  • I have a scenario where i am mapping twp tables using a data integrator

    In that package we have a source table and a target table and mapping are done from source table to target table.

    My requirement is to create a log file which consists of mappings.

    In that log file i just need column names (not values or data) in the way they are mapped

    For example if column 1 in source table is mapped to column 25 of target table.

    In the log file it should look like this

    column 1 in source table is mapped to column 25 of target table

    I need logic for this

    Can anyone help me out

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply