Answer / fiero

Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.

Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.

Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.

Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

What is the default source option for update stratgey transformation?

1 Answers  

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

What is the benefit of session partitioning?

0 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---

What are the different types of Type2 dimension maping?

1 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

What is metadata reporter?

1 Answers   Informatica,

---

What are the scheduling options to run a sesion?

2 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---