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

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

How do you load alternate records into different tables through mapping flow?

0 Answers  

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

How you count the number of records available at your source?

3 Answers   Zensar,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

What is lookup change?

0 Answers  

What are the join types in joiner transformation?

1 Answers   Informatica,

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

For more Informatica Interview Questions Click Here
Categories