Hi experts, I have a requirement like creating a data lineage report (at column level) for a bunch of stored procedures. Condition is not to use any third party tools. Is there any Teradata tools which can help us in preparing this ? Expected input : stored proc name / definition , output : which target table/report column is sourced from which column in which table/view?
Any pointer to achieving this would be helpful.
Can you provide a guideline on how to create a dependency report at table level ? For a stored procedure - input could be stored procedure name/definition in text format.