If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.