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

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

how many session run unix environment what command using ?

1 Answers   HCL,

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

what is the difference between repository & Intergration service

1 Answers  

What are the transformations that are not supported in mapplet?

0 Answers  

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

how can we run workflow with pmcmd?

3 Answers   Wipro,

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

For more Informatica Interview Questions Click Here
Categories