Reputation
513
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
3 13 25
Impact
~121k people reached

  • 0 posts edited
  • 1 helpful flag
  • 46 votes cast
Apr
13
answered Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source
Apr
13
asked Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source
Apr
13
answered ODBC Data Source Administrator: Driver name is an empty string
Apr
8
accepted What causes disk space growth from Informatica load onto SQL Server?
Apr
7
answered What causes disk space growth from Informatica load onto SQL Server?
Mar
24
revised What causes disk space growth from Informatica load onto SQL Server?
added 483 characters in body
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, not necessarily. We are a datawarehouse but this database only represents the latest facts, so our type of facts don't change very much in this application. Only the date in which they are being represented. We basically just take the latest facts, so it doesn't grow very much considering we have data from 1988. From the last year, we may have grown a few dozen GB.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Kin, we are using Informatica 9.1. Our mapping is fairly simple, in that we have a source definition, a source qualifier, and a target definition. Nothing fancy. So just a single table with about 2 billion rows.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, we are almost hitting our disk space limit.
Mar
24
asked What causes disk space growth from Informatica load onto SQL Server?
Mar
12
awarded  Notable Question
Feb
4
awarded  Notable Question
Dec
5
accepted Database storage limit for open source PostgresSQL
Dec
5
asked Database storage limit for open source PostgresSQL
Oct
24
awarded  Notable Question
Oct
16
revised ODBC Data Source Administrator: Driver name is an empty string
added 11 characters in body
Oct
16
asked ODBC Data Source Administrator: Driver name is an empty string
Oct
1
comment Best index to apply for modifier query in i2b2
@Kin, I'd like to install that tool, but we have to go through a process to get new tools on our machine. I'll post the actual execution plan from SQL Server when I post the answer.
Oct
1
comment Best index to apply for modifier query in i2b2
Despite how this query runs, this query wasn't intentional. i2b2 has its own query writer, and I discovered a flaw in the query writer. It's excluding an absolutely essential piece of the query (the concept_cd nested query) before the modifiers are queried. I'll post more detail when I get time.
Sep
30
awarded  Famous Question