Data getting duplicated when loaded due to data length issue
We are maintaining our customer support data on VERTICA for Analytics purpose. When we loading data on VERTICA using INFORMATICA, we are finding that Data getting duplicate if any truncation happens.
This issue causing lot of troubles as result we having issue on relying on VERTICA.
Can you please help us.