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

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

---

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---