i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
- 5 Answers
- 9528 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ganesh yadav
using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Mention some types of transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is meant by LDAP users?
Design time, run time. If you don't create parameter what will happen
What are active transformations.
What is incremental aggregation?
How can we use batches?
How might one distinguish in the case of mapping is right or not without associating session?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to update a particular record in target with out running whole workflow?
Explain the etl program with few examples.
State the limitations where we cannot use joiner in the mapping pipeline?
which one is better performance wise joiner or look up
What are the different options available for update strategy?
What is the difference between router and filter?
