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
- 10455 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 is an active transformation?
What does role playing dimension mean?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the measure objects?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Why update strategy and union transformations are active? Explain with examples.
Differentiate between a database and data warehouse?
If informatica has its scheduler why using third party scheduler?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is joiner transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What is joiner change?
What are the various types of transformation?
Make a note of the quantity vaults made in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
