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
What is meant by lookup transformation?
Reusable transformation and shortcut differences
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain sessions and how many types of sessions are there?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
what is the size of u r source(like file or table)?
What is the sql query overwrite in source qualifier in informatica
What are the advantages of using informatica as an etl tool over teradata?
what is Active lock explain
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What if the source is a flat-file?
In informatica workflow manager, how many repositories can be created?
Explain the aggregator transformation?
What are the guidelines to be followed while using union transformation?
Which is the t/r that builts only single cache memory?