. 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 |
How to delete duplicate row using informatica?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
Difference between Data and Index Caches?
If we set dd_insert in mapping and Delete in session properties what will happen.?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Explain pushdown optimization $pushdownconfig parameter - informatica
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
How to extract sap data using informatica?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is mean by throghput? in informatica
what is shortcut in informatica? difference between shortcut,reusable object?