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
Answer Posted / siva
Use 2 variables one for counter and another for value.
sort all the records by c1 and keep track on c1 and hold
the value in v1. When the v1 and c1 are equal, then
concatenate c2 with v2 other assign c2 with v2. Finaly
connct to aggregator and take last value by grouping the
records by c1.
This will work..
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
Informatica Checkpoints
What is the maplet?
What is repository manager?
Differentiate between reusable transformation and mapplet.
Where is metadata stored?
Describe the impact of several join conditions and join order in a joiner transformation?
Describe expression transformation?
Differentiate between a repository server and a powerhouse?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the function of union transformation?
Which is the t/r that builts only single cache memory?
What are session parameters ? How do you set them?
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you update the records with or without using update strategy?