Answer / venkatesh.malneni

here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r


the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3

or if u use sequence generator the flow will be

sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3

Answer / 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

Answer / ankur saini er.ankur861@gmail.

i think the best way to achieve this is to add a cyclic
sequecn gen which will gen 1,2,3 again 1,2,3 again 1,2,3

addd a router then or 3 filters add dump the the data from
sep filters or router groups to the diff targets as
required..

Thanks...

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

---

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  

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---