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
- 10426 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
What are the different components of powercenter?
In warehouses how many schemas are there?
Define pmcmd command?
Sequence generator, when you move from develoment to production how will you reset
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the surrogate key?
How can we improve session performance in aggregator transformation?
What is aggregate cache in aggregator transformation?
How many transformations can be used in mapplets.
How can we delete duplicate rows from flat files?
Where is metadata stored?
How to join three sources using joiner?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Can u generate reports in Informatica?
What are the advantages of informatica?
