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.

What could be the possible resons of locks by user?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---