Answer / manthiramoorthy. g

S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3

In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3

Answer / teja_dwh

By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.

cheers
teja

Answer / rucha

i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively

Answer / gyana

source--->sq--->attached a sequence generator with settings

current value=1
start value=1
end value=3
incrimented by=1
cycle=yes

------->router(3groups)--->3 targets

Answer / koti

hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

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

0 Answers  

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

---

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,

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---