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
- 6732 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 the command used to run a batch?
Explain the tuning lookup transformation - informatica
What all are steps in up gradation of Informatica server?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the cumulative sum and moving sum?
What are the main issues while working with flat files as source and as targets ?
where to store informatica rejected data?
How to handle decimal places while importing a flatfile into informatica?
What is the sql query overwrite in source qualifier in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
permutations of mapplet
What are the new features of informatica 9.x developer?
Enlist the advantages of informatica.
Enlist the tasks for which source qualifier transformation is used.
What are the static cache and dynamic cache in informatica?
