Reputation
569
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 13 29
Impact
~150k people reached

  • 0 posts edited
  • 1 helpful flag
  • 52 votes cast
Aug
20
revised Multi-thread Informatica connections to use different processors on target database server
added 213 characters in body
Aug
20
accepted Multi-thread Informatica connections to use different processors on target database server
Aug
20
answered Multi-thread Informatica connections to use different processors on target database server
Aug
19
asked How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?
Aug
6
awarded  Popular Question
Aug
3
awarded  Caucus
Jul
31
awarded  Popular Question
Jul
31
awarded  Popular Question
Jul
24
comment Multi-thread Informatica connections to use different processors on target database server
You're speaking from a SQL Server perspective, correct? From an Informatica perspective, I'm wondering if we need 4 separate connections for the same database, and then use a different connection for each command task?
Jul
24
asked Multi-thread Informatica connections to use different processors on target database server
Jul
22
comment Can data streams from Informatica to SQL Server be multi-threaded?
Max - if it's a single mapping, would I just put in a SQL override (target "SQL Query" field) and filter the records of the target table to 25% in four different session tasks, that all point to the same mapping, assuming I have a four core processor?
Jul
21
comment Can data streams from Informatica to SQL Server be multi-threaded?
Kin - EXEC sp_configure 'max degree of parallelism' .... gives 5 columns in its output: name: max degree of parallelism, minimum: 0, maximum: 1024, config_value: 0, run_value: 0 ... are we looking at the config_value or the run_value??
Jul
21
asked Can data streams from Informatica to SQL Server be multi-threaded?
Jun
12
comment How to resolve red invalid icon for Informatica mapping
That's a great question. I didn't receive the error in that use case. My issue happened when a target definition was created. Are you getting this error on a source definition our something else (different object type)?
May
31
accepted SQL Server 2008: Diff table data on different servers with exact schema
May
31
accepted Netezza Equivalent to T-SQL ROWVERSION or PL/SQL ORA_ROWSCN
May
31
accepted How to resolve red invalid icon for Informatica mapping
May
31
accepted ODBC Data Source Administrator: Driver name is an empty string
May
31
accepted Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source
Apr
29
accepted Fastest way to disable indices and drop constraints and rebuild SQL Server table