source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
Answer Posted / rajesh
use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What does role playing dimension mean?
What is a joiner transformation and why it is an active one?
Different sorts of metadata that stores in the storage facility?
What are roles and groups and benefits of using them?
Performance tuning in UNIX for informatica mappings?
What is enterprise data warehousing?
Explain constraint based loading in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What differs when we choose the sorted input for aggregator transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the sequence generator transformation in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the settings that you use to configure the joiner transformation?
What is sorter transformation?