i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
Answer Posted / mahesh
using Aggregator ......
create group by on col1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is union transformation in informatica?
define galaxy repository in informatica
State the differences between sql override and lookup override?
Quickly characterize reusable change?
How to differentiate between the active and passive transformations?
Explain how many types of dimensions are available in 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?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Describe an informatica powercenter?
What are the designer tools for creating transformations?
How do you change a non-reusable transformation to reusable transformation?
Explain load alternative records / rows into multiple targets - informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain what transformation and how many are there in informatica?
which one is better performance wise joiner or look up