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

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1694


design of staging area?

1832


Clarify the aggregator change?

803


Enterprise data warehouse your projects phase by phase explain?

1698


Explain direct and indirect flat file loading (source file type) - informatica

1103


What is the difference between writing a joiner query in ANSI style and THETA style?

2172


Differentiate between joiner and lookup transformation?

879


Separate from a database, an information bazaar, and an information stockroom?

853


What is a joiner transformation?

783


What are the steps involved in the migration from older version to newer version of Informatica Server?

1860


What is the difference between Active and Passive transformation?

892


What do you mean by worklet?

851


what is SDLC way of code development?

1801


What is intricate mapping?

829


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

882