Answer Posted / anvesh

A variable which is created in workfow manager is called workflow variable. This is used for many tasks, for example.. I created a mapping level variable, which is not assigned with initial value. So by using this Workflow variable we can assign value to the mapping variable.

For this we have to use assignment task.

WF-> Assignment task -> Session(non reusable)

First create a variable in workflow manager, go to workflow-> edit -> add a port. In this assign a name to the variable. Now create assignment task in workflow manager. In this create a new port. Now name it as the name given to mapping level variable and assign a value to this variable.

Now go to session properties -> command, then give $$ mapping variable = $$ Session variable.

this will wrk... if not pls reply me...

What is a mapplet/worklet in informatica?

1120

---

How to go to the older version for a mapping?

1028

---

what is the hint? how to use it to reduce the query processing in program?

7629

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195

---

Please let me know how to make Data masking in informatica..

1663

---

State the limitations where we cannot use joiner in the mapping pipeline?

994

---

What are the different lookup cache(s)?

1033

---

How do you update the records with or without using update strategy?

1055

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1226

---

In which transformation you cannot drag ports into it?

1243

---

How to generate sequence numbers?

1029

---

what is informatica metadata?

975

---

What do think which one is the better joiner or look up?

1143

---

Clarify the aggregator change?

970

---

What are data-driven sessions?

1143

---