I would like to know if it is possible to exploit or have access to certain fixed properties associated with SQL Steps in a Data Warehouse Center (DWC) environment
Example: a step has a source table and that table has a name. I would like to be able to refer to that name through some kind of constant like "&src_name" and use such a constant in the SQL Expression Builder;
To my knowledge, such a constant does NOT exist (the only ones I am aware of are time-related constants such as &cur_dd). I thus wonder if anyone out there tried to build such constants, and whether he/she was successfull...