Answer / babu

Hi,

Wf-->s1-->Assignmenttask(var=var+1)--mod(var,5=0)-->s2
here var is variable it is declared in workflow level.
if every run of workflow var value increase 1,whenevr the
var reaches the value is 5 then only s2 will run.



Babu

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

What is expression transformation?

0 Answers  

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

How does the aggregator transformation handle null values?

0 Answers  

---

in oracle write query yourname+1 from dual

5 Answers  

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---