Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

. 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

Question Posted / srinivas.medagum

Answers were Sorted based on User's Feedback



. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

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

. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

Answer / maneesh

Aggregator can do this easily

Is This Answer Correct ?    0 Yes 0 No

. Design a mapping, first two phone calls received by a customer must be represented as "Home&..

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

Post New Answer

More Informatica Interview Questions

Explain in detail scd type 2 through mapping.

0 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

.prm wirh repalce .txt is possible?

2 Answers  

What are the active and passive transforamtions?

2 Answers  

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

What is the reusable transformation?

0 Answers  

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

What is DR strategy for Informatica project?

0 Answers  

list out all the transformations which use cache?

0 Answers   Informatica,

what is the look up transformation?

2 Answers   Informatica,

Can we get 1st record through Informatica(without sequence number).

0 Answers  

For more Informatica Interview Questions Click Here
Categories