We are planning to create a Data Lineage at Column level from TD stored procedure. Identifying all the source columns and tables (including Join/Where columns etc.) related to a target column is what we are looking for.
Please suggest if there is any automated way to do it?
Gopi, did you try getmanta.com? It is an automated data lineage solution designed not just for Teradata BTEQs and procs, but also for other kinds of programming code like Oracle PL/SQL, MS SQL server scripts and many others. I recommend to check it. Tomas