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 is the size of u r source(like file or table)?
where to store informatica rejected data?
What is rank transformation?
What is domain in terms of informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What could be the possible resons of locks by user?
What is mapplet in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to call shell scripts from informatica?
What are the differences between source qualifier and joiner transformation?
Informatica settings are available in which file?
how to load rows into fact table in data warehouse
What are the components of workflow manager?
What is meant by a domain?
What is meant by LDAP users?