The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
22 views

Multi-thread Informatica connections to use different processors on target database server

See this question for reference. Can data streams from Informatica to SQL Server be multi-threaded? I've got most of my problem figured out. I've split up the one large table into four smaller ...
2
votes
0answers
29 views

Can data streams from Informatica to SQL Server be multi-threaded?

Suppose we have a database server, with SQL Server on it. And we are moving data from another database server, through our Informatica server, and onto that SQL Server database server. And our SQL ...
0
votes
1answer
32 views

Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source

Informatica just hangs when trying to open this dialog. The ODBC connection exists in Control Panel > Administrative Tools > ODBC Data Sources. Source Analyzer > Sources (menu) > Import from ...
0
votes
2answers
55 views

What causes disk space growth from Informatica load onto SQL Server?

We've been dealing with huge disk growth on SQL Server from Informatica. After the load, the database grows to 2.4TB. After the database shrink, it goes to 1.05TB. What could likely cause this to ...
0
votes
0answers
18 views

FACT table loading

I have the below table structure : Ticket# Tckt_type Amount Acct Num 1 abc 10 1001 1 def 20 1002 So, for the same ticket number, there ...
2
votes
1answer
989 views

How to resolve red invalid icon for Informatica mapping

I'm having a difficult time resolving a red "invalid" icon within Informatica. I've done all possible scenarios for checking in / checking out this object (mapping). It currently does not have any ...
0
votes
1answer
373 views

How do I debug an ETL process that is unable to commit any records?

I used a DB link to connect to another DB and delete a couple of records. Later I ran an Informatica Workflow (ETL tool) to load data into that database using a DB connection that connects directly to ...
2
votes
1answer
5k views

Why do I get an incorrect error “ORA-01775: looping chain of synonyms”, when the base table does not existing?

I use Informatica for managing some ETL process that load data into an Oracle 9i Data-warehouse. Today I got the below error in the Informatica session logs: Message: Database driver error... ...
2
votes
1answer
2k views

Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file

Reference: https://community.informatica.com/message/62128 Windows ODBC Workflow: Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > ...