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
- 11060 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 is the complex transformation you used in informatica
What you know about transaction control transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What are multi-group transformations?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How can we use batches?
Explain what are the different types of transformation available in informatica.
What is meant by active and passive transformation?
What is the difference between Active and Passive transformation?
What is the benefit of session partitioning?
Explain joiner transformation in informatica
Which transformation should we use to normalise the COBOL and relational sources?
What is the command used to run a batch?
