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
- 7004 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
What is a shortcut and copy in Informatica and how two are different with each other?
How can we handle two sessions in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What is an unconnected transformation?
Explain lookup transformation is active in informatica
What is the Rank index port in Rank transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
draw informatica architecture 8.6 ?
Define mapplet?
What is the format of informatica objects in a repository?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
update strategy transformation in informatica
Enlist few areas or real-time situations where informatica is required.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
