top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

IDQ mapping output variables in workflow

+2 votes

How do you include you mapping output variables in the workflow without having to use a human task?

Basically I have one row of data that I want to push out and to be included in e.g. the body of the Notification task or as an attachment.

We are not using power center, only the developer tool.

posted May 26, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+1 vote

Use a flat file output from the Mapping and Command Tasks in the workflow. Check this link in Informatica Data Quality Community forum:

answer May 27, 2014 by Shweta Singh
Similar Questions
0 votes

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

0 votes

I have a scenario where my source file name will be coming from one db table I have to read that value and pass it in the value of Source File Name in Session properties.

Till now I have tried like I have created 2 sessions where the 1st session will read the db table where the source file name is stored and store it in one mapping variable and in post success variable assignment I am assigning the mapping variable value to workflow variable and in the next main session I am trying to give the workflow variable in the session file name attribute .

But it is showing error like below

fail to expand variables in file field [$$WL_File].

How can I achieve this.

Please suggest some ideas.

0 votes

I want to maintain audit information of each and every mapping in table which contains

workflow_name | start_time | end_time | source_success_rows | target_success_rows | error_record_count

i am able to do it using workflow variables assigning them with built-in session variables and then using the property of prevariableAssignment in session assigning the workflowflow variables to mapping variables of audit_session

It is working fine , But the issue is if i want to maintain audit for other mapping i have to create the whole process again . So is there any possibility of automating the process so that it does not require recreation of the whole thing again.

0 votes

For cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.I have startet by joining REP_LOAD_SESSIONS and REP_TBL_MAPPING on mapping_id but only a fraction of mappings seem to be present in the joined output. I can't find the right tables to join to get the job done. Any help will be greatly appreciated!

Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.