Skip to Content
avatar image
Former Member

Extract column mapping from Query transform

Hi All,

How do we extract columns and their mappings for individual Query transforms within Dataflows?

I am trying to extract it from ATL within each Query transform, but it gives only an SQL statement like

SELECT Table_Name.Column_Name1,

Table_Name.Column_Name2,

.....

....

...

FROM Table_Name

WHERE Condition1 = 'Y'.....


This way I am not able to get the target column name.

I tried searching in repository tables AL_COLMAP, AL_COLMAP_NAMES, AL_COLMAP_TEXT, but they don't give desired output.


Any help will be much appreciated.


Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 26, 2015 at 03:24 PM

    Have a look at the view ALVW_MAPPING.I think this is what you need to tweak.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I doubt if there's a way to get all the query transform and their mapping using the repository tables.

      Try exporting the DF as a .xml file and write a parse program to get what you need.

      By the way ,why do you need to do this?.