Interested to Buy Any Domain ? << Click Here >> for more details...
. 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
- 6735 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Global and Local shortcuts. Advantages.
How can we store previous session logs?
Define enterprise data warehousing?
What is source qualifier transformation in informatica?
What is rank transform?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How you prepared reports for OLAP?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Under which circumstances, informatica server creates reject files?
what are the Methods For Creating Reusable Transformations?
what is the complex transformation you used in informatica
explain about unit testing? in real time?
What do you mean by enterprise data warehousing?
Can we create multiple integration service on single repository?
