top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Working with Informatica

0 votes
259 views

I am setting up a dev environment for a project, with informatica 9.1 and SQL Server 2012 on a Windows Server 2008 R2 machine.

Installation etc has finished fine and no issues reported so far.

When we are trying to run our first mapping/workflow, the SQL Server database connectivity is becoming a bottleneck.

I tried creating a native connection to SQL Server, and also odbc, both don't seem to work, the session in question just fails to initialize. The error message finally is

failed to prepare session

Am I missing something here? Any experiences?

Disclaimer: This is my first ever attempt to host Infa repository at SQL Server, and also, using source and target as SQL Server.

posted Aug 19, 2014 by Sunil

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

1 Answer

0 votes

The cause of the "failed to prepare session" error was that one or more objects used by the workflow were checked out. Once everything referenced by the workflow was checked in again, the error went away and the workflow completed successfully.

answer Aug 21, 2014 by Shweta Singh
Similar Questions
0 votes
informatica +pl/sql, working with function and reference cursor

I have a package and I have to execute a function from package whose parameter is session date and return value is a reference cursor. When I connect to database and execute the function, I am getting proper output. When I am executing the same in informatica, it's going wrong at date part. 1) Firstly what can be an approach to execute the function and obtain the data in informatica 2) is this possible by source qualifier transformation or SQL transformation? 2) if there is feasibility how can I pass the date to Oracle

0 votes
Error while working with Informatica Design SDK for creating mapping

I have found the mapping sdk code samples, however without any documentation whatsoever.

Currently working with 9.0, I am looking for more info.

For one of the current issues, when I try to save the mapping to repository, (with pcconfig.properties lying in the same folder where the xml file is being generated), I am getting the following error:

Written the file..

Caught an exception in run() method

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

com.informatica.powercenter.sdk.mapfwk.exception.MapFwkOutputException: Error saving to repository :  Failed to connect to repository

    at com.informatica.powercenter.sdk.mapfwk.xml.XMLWriter.save(Unknown Source)

    at com.informatica.powercenter.sdk.mapfwk.repository.Repository.save(Unknown Source)

    at TestRaghavExample.generateOutput(TestRaghavExample.java:259)

    at TestRaghavExample.create(TestRaghavExample.java:64)

    at TestRaghavExample.main(TestRaghavExample.java:272)

Caught an exception in run() method
This is my initial example.. trying to find my way through the API..

0 votes
Mulitple targets with same name in Informatica?

I am trying to merge multiple targets with same name and I am getting errror.
Please guide me on how to proceed.

+3 votes
What is CDC in Informatica and what is the purpose of using it? Explain with an example?

What is CDC in Informatica, What is the purpose of using it? Please explain with an example?

...