Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have source
101 a
101 b
101 c
101 d i want target like 101 abcd how will u achive this
please give me the answer
- 5 Answers
- 10849 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabodh
S-->SQ-->SORTER-->EXP-->AGG-->TARGET
Sort on the firt port,in exp check prev and curr value by
using var ports,if same concat them ,u will get
101 a
101 a b
101 a b c
101 a b c d
from the Exp trans ,group by first port in the Agg trans ,u
will get last row i.e 101 a b c d.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is a node in Informatica?
Why union transformation is an active transformation?
How to join three sources using joiner?
How can informatica be used for an organization?
While migrating the data from one environment to another environment how would you manage the connections?
What is dynamic cache?
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
How might one distinguish in the case of mapping is right or not without associating session?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to elaborate powercenter integration service?
What will be the approach?
Write the prerequisite tasks to achieve the session partition?
What is sq transformation?
What are the differences between joiner transformation and source qualifier transformation?
Is there any way to read the ms excel datas directly into informatica?
