Hi , I think people would have asked the question but i am not able to find the answer. Hence asking again “Is there a way we use same extractor for example tap-postgres and connect it to 2 different source in same meltano.yml file?”

Have you checked out the "inherit_from" syntax? This allows you to have multiple named instances of the same tap, with config settings partially or fully overriden in each instance: https://docs.meltano.com/concepts/project#inheriting-plugin-definitions

Thanks @aaronsteers . I saw it but have not actually used it but will now and update