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
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
design of staging area?
Clarify the aggregator change?
Enterprise data warehouse your projects phase by phase explain?
Explain direct and indirect flat file loading (source file type) - informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
Differentiate between joiner and lookup transformation?
Separate from a database, an information bazaar, and an information stockroom?
What is a joiner transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the difference between Active and Passive transformation?
What do you mean by worklet?
what is SDLC way of code development?
What is intricate mapping?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?