Interested to Buy Any Domain ? << Click Here >> for more details...
. Design a mapping, first two phone calls received by a
customer must be represented as "Home" , "Office" and the
next calls must be concatinated and represented as
"Other".Look at the below tables ::
Source Definition
Customer Phone_Number
A 9848403211
A 9812675432
A 9112356788
A 9876503276
B 9567890765
B 9876098567
AND THE TARGET IS
Customer Home Office Other
A 9848403211 9812675432 9112356788,9876503276
B 9567890765 9876098567 Null
- 3 Answers
- 6736 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas.medagum
WE CAN USE GROUP BY CUSTOMER
CONCAT(FIRST(Phone_Number).......>HOME
CONCAT(LAST(Phone_Number).......>OTHER
BUT HOW CAN I FETCH THE MIDDLE RECORDS?
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
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
What all are steps in up gradation of Informatica server?
what is informatica metadata?
What are multi-group transformations?
What is informatica metadata and where is it stored?
Differentiate between Load Manager and DTM?
how many types of dimensions are available in informatica?
What are the differences between a connected lookup and unconnected lookup?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is lookup change?
What is a repository? And how to add it in an informatica client?
What is meant by a domain?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the performance considerations when working with aggregator transformation?
What is domain and gateway node?
