Answer / susanta

Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.

after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.

Hope this will help u

Answer / ks316

Hi all,

I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.

I think there should be a condition to every group in the
router.


i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,

pls correct me if i am wrong

Answer / avatar dss42b88

for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure

sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like

start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.

How can we update a record in the target table without using update strategy?

0 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

what is runtime variable?

3 Answers   TCS,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

Name the different lookup cache(s)?

0 Answers  

---

What is a candidate key?

7 Answers   CTS,

---

what is left outer join?

3 Answers   L&T,

---

What is source qualifier transformation?

1 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

What is synonym?

2 Answers   Patni,

---