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
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
Differentiate between router and filter transformation?
What are the types of lookup transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the way to execute pl/sql script using informatica mapping?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
On which transformations you created partitions in your project?
Explain the types of lookup transformation?
Explian the Process of deployment groups in informatica
Which version configuration tool used in ur project?
Explain sessions?
can we override a native sql query within informatica? How do we do it?
Can we create two repositories on same database instance in oracle?
Can you use flat files in Mapplets.
How to extract the informatica rejected data?
What is option by which we can run all the sessions in a batch simultaneously?