Answer / mithilesh kumar rai

step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.

step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.

Answer / davankumar

1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...

Answer / vidyadhar tilve

use transaction control

Answer / ramakrishna

simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

what is surrogate id ?

3 Answers   IBM,

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

---

what is hash table in informatica?

1 Answers   Zensar,

---

how to convert the .doc docs into .txt format using informatica

4 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

What is the use of source qualifier?

0 Answers  

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---