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
- 6896 Views
- I also Faced
- E-Mail Answers
Answer Posted / maneesh
Aggregator can do this easily
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
What is dimensional table?
Explain 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?
Enlist the tasks for which source qualifier transformation is used.
Explain what are the different versions of informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you load first and last records into target table?
what is the size of your data warehousing?
What is meant by incremental aggregation?
How to extract sap data using informatica? What is abap? What are idocs?
What are the advantages of informatica?
Reusable transformation and shortcut differences
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain incremental aggregation in informatica
Different sorts of metadata that stores in the storage facility?
