I am facing a very strange issue.
I am trying to run a ETL in UAT environment but it is getting failed with error (table or view does not exist) , I checked manually and tables exists in both source and target.
Target Data store is pointing to UAT DB and Source is pointing to UAT DB
Then I tried ny pointing the source to SIT and target to UAT and vice versa, it worked.
Not sure why data services is behaving strangely.