Create Rows depending on count in Informatica

Question

I have input data in a flat file, for which I want the specific output file.

    data.csv contains
    A,2
    B,3
    C,2
    D,1

And required output should be

    A
    A
    B
    B
    B
    C
    C
    D

Here I need to create output rows depending upon value in column. I tried it using java transformation and I got the result. Do we have any other way to do it?

Answer 1

If you need an alternative implementation, you can use a helper table and a Joiner transformation.

1.Create a helper table and populate it with appropriate amount of rows (you need to know the maximum value that may appear in the input file). There is one row with COUNTER=1, two rows with COUNTER=2, three rows with COUNTER=3, etc.

2.Use a Joiner transformation to join data from the input file and the helper table - since the latter contains multiple rows for a single COUNTER value, the input rows will be multiplied.

COUNTER
-------------
1
2
2
3
3
3
4
4
4
4
...

Depending on your RDBMS, you may be able to produce the contents of the helper table using a SQL query in a source qualifier.