'Informatica performance issues with snowflake target
I'm facing an performance issue with informatica hotfix 1 when loading huge data around 250 Millions into snowflake target from oracle sources, we have two versions one load into teradata which has no problem of performance (3-4 hours) and the second which load snowflake for this one the Throughput(row/sec) start correctly around 15K but it decrease to 2K and take so much time to load the data (more than 23 hours).
the mapping is a simple one I have source(oracle)--> Source qualifier (simple sql) --> expresion (without transformation) --> target (snowflake).
I don't have any warning message in the logs (there was "waiting for buffer increase" which I already fixed).
have you faced the same issue or any idea about please?
amazon-elastic-beanstalk
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|