Interested to Buy Any Domain ? << Click Here >> for more details...
source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
- 6 Answers
- 10825 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / anoymous
If the source is Relational then source qualifier can be
overridden
Select Col1, Concat('col1',',','col2') from table name
groupby col1;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are the popular informatica products?
What are the limitations of joiner transformation?
what is $$$$?
Explain informatica architecture - version 8 / 9
In how many ways we can create ports?
I have a flat file, want to reverse the contents of the flat file
Plz can any one say me how to get the informatica certification materials and dumps
Define filter transformation?
what is informatica metadata?
Where do we use mapping variables in informatica?
What is the function of aggregator transformation?
What is repository manager?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the components of Informatica? And what is the purpose of each?
What is the difference between informatics 7x and 8x and what is latest version?
