PowerExchange for Snowflake
Effective in version 10.2.1, PowerExchange for Snowflake includes the following features:
- You can configure a lookup operation on a Snowflake table. You can also enable lookup caching for a lookup operation to increase the lookup performance. The Data Integration Service caches the lookup source and runs the query on the rows in the cache.
- You can parameterize the Snowflake connection, and data object read and write operation properties.
- You can configure key range partitioning for Snowflake data objects in a read or write operation. The Data Integration Service distributes the data based on the port or set of ports that you define as the partition key.
- You can specify a table name in the advanced target properties to override the table name in the Snowflake connection properties.
For more information, see the
Informatica PowerExchange for Snowflake 10.2.1 User Guide.