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..

explain different types of modeling.

2 Answers  

---

Mention a few design and development best practices for informatica?

0 Answers  

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

How to merge First Name & Last Name?

8 Answers  

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

What is source qualifier?

6 Answers   SDS,

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---