Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X
either as a source or target table?
Right click on the source or target in the Designer and select Dependencies. In Object Types select 'Mappings' and 'Workflows' and click OK