. 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
Answers were Sorted based on User's Feedback
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 |
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 |
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What are the uses of etl tools?
Explain the scenario which compels informatica server to reject files?
what is curr val use for in sequence generator?
What do you mean by worklet?
what are types of dimentions?
Implementation methodology
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is sorter transformation?
What is a look up function? What is default transformation for the look up function?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000