Extract column mapping from Query transform

[Former Member]

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.

[mageshwaran_subramanian]

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

[Former Member]

Thanks Magesh.

I saw the table, but still doesn't give the column mapping by individual query transforms within the dataflow.

It works only when there is a single Query in the dataflow.

[mageshwaran_subramanian]

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?.