5 Replies Latest reply on Jun 27, 2021 12:25 PM by Uma Mahesh Chalasani

    ODBC connector to Snowflake without Cloud version of Informatica

    Sue Davis New Member

      We have an on prem power center license for address and name cleaning that we plan to use for some processing of data residing in Snowflake that will need to be written back into snowflake.  Currently, the process extracts fine and goes through the address cleaning without any issues.  The load back into Snowflake is ridiculously slow and painful at about 85 records per minute.  I am told there is no way to speed that up without upgrading our Informatica to the cloud version which I cannot do for several reasons.  What options do I have aside from landing the data into a flat file and loading as a bulk load into Snowflake.  I am told Power Exchange is not an option.  Thanks,