. 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
- 5990 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
What is workflow manager?
Why is sorter an active transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How would you copy the content of one repository to another repository?
Mention a few design and development best practices for informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
-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?
How are indexes created after completing the load process?
How we can use union transformation?
I have a flat file, want to reverse the contents of the flat file
Explain how to import oracle sequence into informatica?
Difference between Data and Index Caches?
What is workflow monitor?
What are the modules in Power Center
