Answer / Raman Jeet Singh

To convert a single row from a source into three rows in the target table, you can use multiple 'Copy Data' transformations and perform calculations within each transformation.nnMapping steps:
1. Create your target table with columns corresponding to the desired output structure (three times the number of original columns).
2. Add your source and a 'Source Qualifier' transformation (to cleanse and filter data if necessary).
3. After the 'Source Qualifier', add three 'Copy Data' transformations in series.
4. In each 'Copy Data' transformation, perform calculations to extract different parts of the original data row into separate columns.
5. Load the transformed data into your target table.

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

What is event and what are the tasks related to it?

1 Answers  

---

How many number of sessions that u can create in a batch?

3 Answers  

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

Performance tuning in UNIX for informatica mappings?

1 Answers   CGI, CTC,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

What is the Router transformation?

2 Answers   Informatica,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1 Answers  

---