Search found 11 matches

by sean
Wed Feb 13, 2013 4:34 pm
Forum: Informatica PowerCenter
Topic: Slow inserts through Informatica
Replies: 4
Views: 3823

Re: Slow inserts through Informatica

Hi, I see this error occasionally when loading data into Vertica through Informatica 9. Severity: INFO Timestamp: 2/13/2013 7:31:29 AM Thread: WRITER_1_*_1 Process ID: 30245 Message Code: VERTICA_WRITER_1762 Message: [DEBUG] No response from the backend Can anyone please shed some light on what migh...
by sean
Fri Oct 26, 2012 7:45 pm
Forum: Informatica PowerCenter
Topic: Slow inserts through Informatica
Replies: 4
Views: 3823

Re: Slow inserts through Informatica

Thanks

However, I notice this issue only occasionally. I have other jobs running with 10k commit interval which run without issues.
I'll try with the commit interval change anyway.

Thanks,
Sean
by sean
Fri Oct 26, 2012 2:38 pm
Forum: Informatica PowerCenter
Topic: Slow inserts through Informatica
Replies: 4
Views: 3823

Slow inserts through Informatica

Hi, I'm using Vertica plugin for Informatica 9.1 to insert data. The speed is generally good. But every once in a while its slows down to a trickle and I see the informatica session logs fill up with this message: [INFO] accepted 104 rejected 0 144537824 Anybody know what would cause this? Could thi...
by sean
Mon Oct 01, 2012 3:21 pm
Forum: New to Vertica Database Administration
Topic: Privileges to load data
Replies: 4
Views: 2133

Re: Privileges to load data

I'm on Vertica version 5.1.4. My user has USAGE privileges on the schema but i still wasn't able to create projections on the tables. The DBA gave CREATE privileges to the user and it worked then. But glad to know that version 6 does need any explicit grants for projections. we are in the process of...
by sean
Thu Sep 27, 2012 5:25 pm
Forum: Informatica PowerCenter
Topic: Vertica lookup in Informatica
Replies: 2
Views: 2511

Re: Vertica lookup in Informatica

To load data, I'm created a connection of type "VerticaConnection" in the workflow manager and that worked when inserting data into Vertica. However, I added a lookup to the mapping, but that connection does not show up in the list for the lookup

The vertica drivers I have is version 5.1.4
by sean
Thu Sep 27, 2012 5:03 pm
Forum: Informatica PowerCenter
Topic: Vertica lookup in Informatica
Replies: 2
Views: 2511

Vertica lookup in Informatica

Hi,

Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?

Thanks.
by sean
Wed Sep 26, 2012 3:25 pm
Forum: New to Vertica Database Administration
Topic: Privileges to load data
Replies: 4
Views: 2133

Re: Privileges to load data

Yes I did

Go to advanced search