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
- 11224 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 can we do to improve the performance of informatica aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Which are the different editions of informatica powercenter that are available?
What is DR strategy for Informatica project?
How do you migrate data from one environment to another?
What is a filter transformation and why it is an active one?
what is index?how it can work in informatica
What are the new features of informatica 9.x in developer level?
What is a transaction control transformation?
Please let me know how to make encryption and decryption with example?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the advantages of using informatica as an etl tool over teradata?
Briefly define a session task?
How many number of sessions can one group in batches?
