. 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
Answer Posted / maneesh
Aggregator can do this easily
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the new features of informatica 9.x in developer level?
What is union transformation in informatica?
How do we call shell scripts from informatica?
explan ur project architecture?
What are junk dimensions?
What is the need for an etl tool?
What are the different versions of informatica?
What is transformation?
What is the use of transformation?
can we override a native sql query within informatica? How do we do it?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the code page compatibility?