The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
30 views

need to get data from Global Temp Table from db1 to db2 and show the data in Oracle form

I need to get data from Global Temp Table from oracle db1 to db2 and show the data in an Oracle form. In db1, a stored procedure is populating data in the GTT and showing it on Oracle forms as this ...
2
votes
0answers
21 views

How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?

What settings or configuration on the Informatica server, in the Informatica software itself, or on the database servers can be changed to increase Informatica ETL throughput? What are some ...
1
vote
1answer
36 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
33 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
43 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
57 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
1k 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
384 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" > ...