Hi All, Is sombody encounter below issue, and how do you deal with it? We are loading data from Vertica source tables to Vertica Target tables, when we process more than 1 million ~ 1.5 miliion recourds one time, the workflow will failed, and here is the specific error information: Message: SQL Erro...

Hi Knicely, it is interesting that, in our porject,there are 10000+ records in the calculated table, when I sum part of them with: sum(REPLACE(Column_A, ',', '.')) as SUM_COA, for example 500 rows, it displays two decimal, but when sum of it for all 10000+records., it will show : 847667.639999999. I...

Hi All, In project we are doing a sum calculation, before that we should convert this kind of char data '12,32' to '12.32', and then we want to get sum of '12.32' kind of data. our logic is here: sum(REPLACE(Column_A, ',', '.')) as SUM_COA However, it is strange that, the sum result is like that: 84...

Hi all,
Te answer is yes. We have done that.

thanks sKwa. I also made some try and yes you are right: it doesn't matter what is a delimiter, only pattern indicators:

in Informatica, what I used is:
TO_DATE(Valid_date_string, 'YYYY-MM-DD')

I have tried, it works.

Hi All, I have question for create vertica connection in Informatica Server (HP-UX). Does it need a username/password/server information written in some ODBC configuration document in server side, such as ODBC.ini or others ? I just want to make sure whether this conncetion creation in Informatica H...

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?...