top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

SQL Server repository for informatica powercenter

0 votes
552 views

I have a powercenter 9.1 installation on windows server 2008 R2. The repository is on the same box, hosted on sql server 2012. I have configured a new user (with sql server authentication) and have the repo db owned by that user. (it has the owner role)

The core problem : I am not able to run a simple test workflow on this setup.

Here's what I have been trying

The windows firewall has been taken down now for about an hour or so.

The repository service and integration service are running in trace/debug mode respectively.

The integration service log complains that it cant find a certain session for a certain workflow in certain folder (with ids for all of them).

When I log into sql server mgmt console, and try to query the repository tables for those exact items (since i have the ids from logs), all the data is present...

I fail to understand what is that I am messing up

posted Sep 1, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Try keeping the sql server login/user name and the associated default schema name as same.

answer Sep 2, 2014 by Shweta Singh
Similar Questions
0 votes
Informatica: reduced performance for simplet one to one mapping when target change from Oracle to SQL Server

I have simple informatica(9.1) mapping(one to one) which loads data from flat file to RDBMS

it take 5 mins to load to Oracle db and 20 mins to load same file in SQL Server 2008 R2.

Can there be any source/pointers for performance improvement

0 votes
Autocommit behavior for DB2 stored proc called from informatica powercenter

I have a stored procedure being called from an informatica mapping. There are no manual commits inside the procedure and the procedure is created with 'COMMIT ON RETURN NO'

I can see the updates done inside the procedure being committed. I think this could be because of the auto commit setting in the Informatica Server. (And I assume the 'commit after end of file' option in the task properties does not apply to stored proc calls)

If this is the case,assuming I do not want to commit anything even if procedure completes without errors, where do I find the autocommit setting (BD2 Driver configuration/Informatica configuration) and change it?

0 votes
Searching for a source table in search criteria in Source analyser in Informatica PowerCenter

This may be a naive question, but I am stuck on this simple one. I have to import a specific source table from the source database. I could see only a few schemas and not all (as there are thousands of), hence could not select desired table, so I am specifying the table in search box. But it does not show up anything. I tried using schema.tablename and different combinations but in vain. Infact, when I try searching for the tables that are already visible, they doesn't show up. Where am I going wrong in searching for a specific table? ANy help is appreciated!

+3 votes
Searching for a source table in search criteria in Source analyser in Informatica PowerCenter

I have to import a specific source table from the source database. I could see only a few schemas and not all (as there are thousands of), hence could not select desired table, so I am specifying the table in search box. But it does not show up anything. I tried using schema.tablename and different combinations but in vain. Infact, when I try searching for the tables that are already visible, they doesn't show up. Where am I going wrong in searching for a specific table? ANy help is appreciated!

+1 vote
Database connectivity with Informatica and SQL Server 2008 R2

I have installed Informatica 8.6 on Vmware and SQL Server 2008 R2 installed on my local host. I am not able to connect the Informatica with SQL Server 2008 R2.

Kindly help me as soon as possible.

Thanks in advance

...