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
- 7005 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas.medagum
WE CAN USE GROUP BY CUSTOMER
CONCAT(FIRST(Phone_Number).......>HOME
CONCAT(LAST(Phone_Number).......>OTHER
BUT HOW CAN I FETCH THE MIDDLE RECORDS?
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
Can we get 1st record through Informatica(without sequence number).
Performance tuning( what you did in performance tuning)
Explain scd type 3 through mapping.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is an expression transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the function of look up transformation?
Define joiner transformation?
What are the types of lookup transformation?
What is the difference between a repository server and a powerhouse?
Describe data concatenation?
Which is the t/r that builts only single cache memory?
What is a stored procedure transformation?
How to generate sequence numbers without using the sequence generator transformation?
