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

Define sessions in informatica etl?

0 Answers  

Define the various join types of joiner transformation?

0 Answers  

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

How can you increase the performance in joiner transformation?

0 Answers  

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories