Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 10199 Views
- TCS, I also Faced
- E-Mail Answers
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
can u any challenge your project?
what is the complex transformation you used in informatica
Do you find any difficulty while working with flat files as source and target?
What is pmcmd command?
What is a snowflake schema?
How to load last n records of file into target table - informatica
What is a surrogate key?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Name the different lookup cache(s)?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
To import the flat file definition into the designer where should the flat file be placed?
difference between informatica 8.1.1 and 8.6
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the sequence generator transformation in informatica?
How do you take back up of repository?
