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

Answer / guest

I used workflow variable to update the session status in
database table.

take assignment task for capturing session status by using
workflow variable if you want in depth pls let me know..

What are ETL Tools?

0 Answers   Informatica,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

Enlist the various types of transformations.

0 Answers  

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

what is row level and column level indicator?

1 Answers   TCS,

---