Answer / harish konda

We can achieve this by using Mapping Variable and Mod function.
Create a mapping var. and using the SetVariable() fun increment its value by 1 every time when the session runs succesfully.
And in the Router create 3 groups and give the conditions, Mod($$var,3)=0,Mod($$var,3)=1,Mod($$var,3)=2.
And map each group of Router to 3 different Targets.

Answer / vineet katyal

take mapping variable $$count-to count the number of session runs(initial value as 1 and default value as 1)

from source take the input to expression transformation and add two variable ports
V_flag=DECODE(MOD($$COUNT,3,1'FIRST',2,'SECOND',0'THIRD')
V_count=SET VARIABLE($$COUNT,$$COUNT+1)

now router transformation
three user defined groups
v_flag=first
v_flag=second
v_flag=third

now add three groups to three targets.

after every successful session run the mapping variable value gets updated by 1 in the repository.

first time the variable value will be 1 as SET VARIABLE WILL BE PROCESSED AFTER FLAG VARIABLE PORT 

Answer / kamleshmishra291

Create a mapping variable $$INCR=1

Take Expression Transformation after SQ
In Expression Transformation create a variable port:
v_count_session=IIF($$INCR=4,setVariable($$INCR,1),setVarialbe($$INCR,$$INCR+1))

After Exp take a ROUTER Transformation and create three groups with conditions :
GROUP1
$$INCR=1
GROUP2
$$INCR=2
GROUP3
$$INCR=3

Finally connect groups to group1--tgt1, group2--tgt2, group3=tgt3

Answer / bhupal

Hi all,

Use sequence generator to generate the sequence.
properties should be
start value=1
end value=3
check the cycle option.

connect this nextvalue port to router and make there groups.

group_1----> nextvalue=1
group_2----> nextvalue=2
group_3----> nextvalue=3


connect first group to first target and second group to second target and then third to third.


flow will be like this
sequence generator
|
source---->source qualifier---->router--------Target 1
|-----------Target 2
|-----------Target 3


please let me know if you have any new questions.
mail id: bhupalreddy200@gmail.com

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

what is lookup chache?

1 Answers   Patni,

---

star and snowflake schema?

6 Answers  

---

What is the difference b/w natural key and surrogate key

1 Answers  

---