. Design a mapping, first two phone calls received by a customer must be repres

. 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

Question Posted / srinivas.medagum

3 Answers
5738 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

Answer / rahul

in exp trans take variable prot

v1 => first( custer ) as home
v2=> to store the previous value of customer
v3 = count = 1
v4 =. if ( customer = v2 , store its as office and count + 1)

v4 = if ( custmoe = v2 and count < 2 store it as other
else ' ')

i know till changes to be done..

its my guess

Is This Answer Correct ?

0 Yes

0 No

. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

Answer / maneesh

Aggregator can do this easily

Is This Answer Correct ?

0 Yes

0 No

. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

Answer / 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