Search found 11 matches
- Wed Feb 13, 2013 4:34 pm
- Forum: Informatica PowerCenter
- Topic: Slow inserts through Informatica
- Replies: 4
- Views: 22823
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...
- Fri Oct 26, 2012 7:45 pm
- Forum: Informatica PowerCenter
- Topic: Slow inserts through Informatica
- Replies: 4
- Views: 22823
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
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
- Fri Oct 26, 2012 2:38 pm
- Forum: Informatica PowerCenter
- Topic: Slow inserts through Informatica
- Replies: 4
- Views: 22823
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...
- Mon Oct 01, 2012 3:21 pm
- Forum: New to Vertica Database Administration
- Topic: Privileges to load data
- Replies: 4
- Views: 8404
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...
- Thu Sep 27, 2012 5:25 pm
- Forum: Informatica PowerCenter
- Topic: Vertica lookup in Informatica
- Replies: 2
- Views: 17676
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
The vertica drivers I have is version 5.1.4
- Thu Sep 27, 2012 5:03 pm
- Forum: Informatica PowerCenter
- Topic: Vertica lookup in Informatica
- Replies: 2
- Views: 17676
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.
Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?
Thanks.
- Wed Sep 26, 2012 3:25 pm
- Forum: New to Vertica Database Administration
- Topic: Privileges to load data
- Replies: 4
- Views: 8404
Re: Privileges to load data
Yes I did