All Questions
Tagged with informatica-powercenter workflow
14 questions
1
vote
1
answer
775
views
INFORMATICA POWERCENTER: Mapping issue and XML output
I'm a beginner with Powercenter, and I want to convert a relation output result into a xml file.
I have a xsd file with the xml structure.
When I import it into Designer, PWC create automatically the ...
- 13
0
votes
2
answers
707
views
I’m getting below error while I try to execute a workflow on Powercenter
Transformation Parse Warning [<<P M Parse Warning>> <<Invalid constant sun-expression>> <<Expression Error>> [TO_DATE]:invalid string for converting to Date
… t:...
- 1
1
vote
1
answer
181
views
Best practices for Informatica Webservice workflow
I have created a Informatica webservice workflow which takes 1 parameter as input. A Webservice provider source definition is used for this and mapping is a one-way type.
Workflow works fine when ...
- 11
0
votes
1
answer
498
views
How to configure workflow runtime (Informatica)?
I would like the workflow to run for 20 minutes....If the running process does not complete within 20 minutes, the workflow should be ended immediately..However, I can only find the timer, but it is ...
- 805
0
votes
2
answers
423
views
How do I delete unwanted workflow from the sub folder in Informatica?
I tested on a few workflow processes [Under workflow] and I would like to delete some of the unused ones....but the problem is how do I delete them? I tried deleting from the Repository Manager, but ...
- 805
0
votes
3
answers
3k
views
Email Triggered With Success Row count in Target Using informatica
I need to trigger an email with all the stats like Count of Rows which are successfully loaded in the target, Failed rows count with the help of Informatica Powercenter.
So where can I find this ...
0
votes
2
answers
5k
views
WRT_8044 No data loaded for this target Informatica 10.2.0
I am running a task in workflow. I have 2 sources and I am able to fetch the no of records from it. But, unable to insert into target table. All the data types are fine.
I have attached the session ...
- 99
0
votes
1
answer
939
views
workflow fails when adding data from one db to another in oracle
checked in sql developer to confirm table existence and also granted insert, select to the table. help pls!
workflow log -
Severity Timestamp Node Thread Message Code Message
INFO 11/...
- 11
0
votes
1
answer
2k
views
How can I remove irrelevent sessions from an informatica workflow or start new one from scratch?
How can I remove irrelevent sessions from an informatica workflow? I spent 15 minutes on Google and I also couldn't find how to close a workflow to start from scratch, which I also would like to know. ...
- 1
0
votes
2
answers
693
views
Informatica Session not getting exported
I am exporting an Informatica Workflow but the sessions that are a part of it are not getting exported, although the mappings that are associated to these sessions are getting exported.
Is there some ...
- 61
0
votes
1
answer
1k
views
Informatica, Multiple emails sent through one session
I am currently working on creating an Informatica mapping and workflow where I will have to send emails based on when a specific field in the mapping changes. Right now, I have that field sorted and ...
- 399
0
votes
1
answer
1k
views
Assign same Integration Service to Multiple workflows in the same folder : any command or all-done-by-one process?
I want to assign the same IS to several workflows in Informatica PowerCenter 9.6.
Is there any way to do it by single go type command or any process?
0
votes
1
answer
1k
views
How to view server connections of a session or workflow
As an SQA, I need to verify that all connections associated with a set of workflows have been updated. How can I view all connections associated with a workflow? Is there a connection, or connections, ...
- 55
2
votes
1
answer
1k
views
How to mention integration service name during importing workflow in a versioned repository from one environment to another
Whenever I try to import a workflow from Dev/Test environment of a versioned repository into Production environment which is also versioned, I get a option where it asks me if I want to Check in or ...
- 343