Answer / srikanth

try below mapping in mapping designer

source->sourcequalifier->exptf1->trg( for n records)
->exptf2(with
sequencegtf)->routertf(sequence column=1 AND
5)->trginstance(same above trg)

Finally you will get total n+5 records into target. Here i
used only one target. just i taken instance.

It will work..

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

Which kind of index is preferred in DWH?

3 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is the function of union transformation?

0 Answers  

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

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

5 Answers   Patni, Wipro,

---

What is Index Caches size?

0 Answers   Informatica,

---

What is a dimensional model?

0 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---