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


Please Help Members By Posting Answers For Below Questions

what is the size of u r source(like file or table)?

2023


where to store informatica rejected data?

859


What is rank transformation?

765


What is domain in terms of informatica?

779


Different qualification between a related rotate toward the sky and isolates look upward?

777


What could be the possible resons of locks by user?

863


What is mapplet in informatica?

786


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

854


How to call shell scripts from informatica?

776


What are the differences between source qualifier and joiner transformation?

819


Informatica settings are available in which file?

781


how to load rows into fact table in data warehouse

906


What are the components of workflow manager?

810


What is meant by a domain?

861


What is meant by LDAP users?

886