Answer Posted / chandra

this can be done in two ways.....
1st one

after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3

the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3

or
we can use MOD function in EXP Tr we can done this

Different sorts of metadata that stores in the storage facility?

1012

---

What are the new features of informatica 9.x in developer level?

999

---

How to differentiate between the active and passive transformations?

1167

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

---

Differentiate between Load Manager and DTM?

2154

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1810

---

Make a note of the quantity vaults made in informatica?

988

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---

What is the use of an aggregator cache file?

1199

---

What is difference between a gateway node and worker node?

1141

---

What is the difference between Active and Passive transformation?

1152

---

Explain informatica architecture - version 8 / 9

1092

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361

---

What is rank index in rank transformation?

1080

---

can anyone explain me about retail domain project in informatica?

7948

---