HI All,
I am loading 20 millions of data from from one vertica table and target vertica table, and the target table is the reporting tables.
I am using Informatica for this load, do you think it is better to add one sort transformation in the mappping? Will it impact the loading speed of my session?
Looking forward to your suggestions!
Regards,
Informatica: Do we need to add sort transformation?
Moderator: NorbertKrupa
-
DolphinLei
- Newbie
- Posts: 13
- Joined: Thu Jan 10, 2013 9:53 am
Re: Informatica: Do we need to add sort transformation?
Hi!
Depends on transformation.
From my experience, transformation during loads sometimes can improve a loads.
For one customer we transformed md5 values to integers using Vertica's hash function.
So instead of 32 bytes for md5 Vertica should allocate 8 bytes per INT, so loads were faster.
Depends on transformation.
From my experience, transformation during loads sometimes can improve a loads.
For one customer we transformed md5 values to integers using Vertica's hash function.
So instead of 32 bytes for md5 Vertica should allocate 8 bytes per INT, so loads were faster.