Answer / manthiramoorthy. g

SQ-->EXP-SEQ-RTR-TARGETS

Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2

Answer / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Answer / chandra

SQ--->EXP-->ROUTER---->TARs


In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets

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

1 Answers   HCL,

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

what is unique constraint error ?

2 Answers   TCS,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

---

replace multiple spaces with single space.

3 Answers   IBM,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

where to store informatica rejected data?

0 Answers  

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

What is difference between a gateway node and worker node?

0 Answers  

---