. 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
- 5992 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
generate date / time dimension in informatica
how tokens will generate?
Explain what are the different versions of informatica?
How you prepared reports for OLAP?
Where do we use mapping variables in informatica?
What does role playing dimension mean?
What is workflow? What are the components of the workflow manager?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Describe an informatica powercenter?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Is it possible to define a single node as a Gateway node as well as worker node?
r u done any partitions in ur project?
What is a code page?
Explain sessions and how many types of sessions are there?
What is dynamic cache?
