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...

Difference between Data and Index Caches?

644

---

What do you understand by term role-playing dimension?

566

---

Explain what are the different versions of informatica?

651

---

How can we improve session performance in aggregator transformation?

667

---

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

653

---

---

How is union transformation utilized?

561

---

Enlist the tasks for which source qualifier transformation is used.

581

---

What is enterprise data warehousing?

604

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1520

---

Differentiate between sessions and batches?

564

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

625

---

What is the Rank index port in Rank transformation?

664

---

What are the transformations that are not supported in mapplet?

591

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3313

---

What are the informatica performance improvement tips

605

---