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.

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

What is the target load order?

3 Answers   HCL, Informatica,

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

Where is metadata stored?

0 Answers  

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

---

What are Business Components in Informatica?

1 Answers  

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

What is a node in Informatica?

0 Answers  

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

Enlist the advantages of informatica.

0 Answers  

---