Extract column mapping from Query transform
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
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.