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

explain abt ur project architecture?

2232

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2245

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1842

---

What are batches?

1186

---

Write the different tools in the workflow manager?

1117

---

Different sorts of metadata that stores in the storage facility?

1069

---

What is the benefit of partitioning a session?

1235

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1817

---

What's the layout of parameter file (what does a parameter file contain?)?

2437

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1711

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3923

---

What is an expression transformation?

1077

---

Explain what is informatica metadata and where is it stored?

1108

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

what is Active lock explain

2857

---