Reputation
539
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 13 25
Impact
~137k people reached

  • 0 posts edited
  • 1 helpful flag
  • 49 votes cast
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
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
I don't know. I'm not an expert in this area. :-\ I just know that with Netezza, our data warehouse's DBMS, it doesn't even have indices in it when they do bulk inserts. They run RI checks after ETL loads. But we are using SQL Server, so I don't know the best approach.
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
Well, isn't it a bad idea to have an index if you have 3 billion rows inserted into it? Isn't it better (and more efficient) to not have the index so it doesn't have to do referential integrity on each insert?
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
MarkSinkinson - how do I handle the other 6 commands, if we do a simple truncate?
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
Yes, after dropping that index, and adding data, we're creating the same clustered index again. Not sure why I have ONLINE = OFF. I'm moving this code from Pentaho Kettle to Informatica. So if we TRUNCATE TABLE OBS_FACT, what should the exact steps, and order be?
Apr
29
revised Fastest way to disable indices and drop constraints and rebuild SQL Server table
added 74 characters in body
Apr
29
asked Fastest way to disable indices and drop constraints and rebuild SQL Server table
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.