I have a table, in that I have few columns. I want to know list of mappings where these columns are used.
Eg: I have a table EMPLOYEE, in that I have columns named EMPNO, ENAME, DEPTNO, SAL, COMMISSION. As part of impact analysis, I want to know list of maapings where ENAME was used.
To achieve this, I went to METADATA, went to the required table, right click on that, you will find an option "Impact Analysis". I clicked on that and provided tablename and column name. However I don't see any list. Could you please let me know whether anything is missing here?
First, make sure there exists job read this table.
Click the 'Impact Analysis' item, it will open the Impact Analysis viewer, for example