sql server – informatica power center On-premises & Azure SQLMI cloud database performance issue

informatica power center On-premises & Azure SQLMI cloud database performance issue

Earlier :
Database - sybase on-premises
informatica power center - on-premises
source - .txt file (1.8 million rows)
major transformation - Using 4 unconnected stored proc transformation (very simple logic nothing complex)
Target - flat file

Logic – for every rows from source it calls stored proc and return the o/p.

it is calling stored proc for each source record means if source has 1.8 million records it will coll proc for 1.8 million time from power center to sqlmi database

Total time to run the job 18 million records – less than 2hr

Current scenario:  the only change we made is migrated our database to Azure SQLMI cloud database.
connection  - sql server ODBC (we also tried sql server relational conn)

and Total time it is taking to execute entire job is 24hr
performance has drastically reduces

has anyone faced this situation? what solution you have tried?

we tried changing connection from ODBC to
sql server relational connection