Answer Posted / prasad

In that case we use Normalizer transformation.
SQ--->Expression----->Normalizer----->TGT

1.Drag the ports from SQ to Expression TX.
2.In Normalizer TX we can assign the occurrences as
for ramu record define the occurrences as 3
for sam record define the occurrences as 5
for tom record define the occurrences as 8

It makes to split the record in to the desired no of times..
Hope it will work.

Please correct me if any mistakes in my answer...

What is informatica etl tool?

942

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

---

Why do we need informatica?

928

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1026

---

What are the types of caches in lookup?

978

---

Performance tuning( what you did in performance tuning)

1910

---

What you know about transaction control transformation?

938

---

What is the different lookup cache(s)?

1037

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1909

---

Why update strategy and union transformations are active?

991

---

What is enterprise data warehousing?

988

---

wat are deployement groups in informatica, how it will be used for developers

1670

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1933

---

What are the features of complex mapping?

1099

---

How do you change a non-reusable transformation to reusable transformation?

946

---