. 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
- 5726 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
Can we create two repositories on same database instance in oracle?
How can we delete duplicate rows from flat files?
How do you change a non-reusable transformation to reusable transformation?
How can informatica be used for an organization?
What are the different lookup cache(s)?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the new features of informatica 9.x at the developer level?
Explian the Process of deployment groups in informatica
Define filter transformation?
Where are the source flat files kept before running the session?
COM components can be used in Informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How can a transformation be made reusable?
Briefly define a session task?
