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

The structure of source file is as below:
Source structure(two fields)
Name, Card NUmber
A, 111111111(SSN)
A, 01010101(Creditcard number)
A, 34343434(Debit card number)
B, 55555555(Creditcard number)
C, 77777777(Debit card number)


Target Structure(4 fields)
Name,Credit card,SSN,Debit card
A,01010101,111111111, 34343434
B,55555555,,
C,,,77777777

Corresponding to one name there can be maximum 3 rows and
minimum zero rows.
Given that I do not know which record might have a
particular type of number.
How can I handle above requirement with informatica
transformations?

Question Posted / curiousmind23


The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 11111..

Answer / abhishek kumar

in this qn ,if B and C will be SSN THEN BY THROUGH RANK
T/F , AGGEREGATOR WE CAN SOLVE THE PROBLEM.
RANK T/F
1)NAME- GROUP BY
2)CARD NUMBER -DO RANK ON NAME COLUMN
3)IN PROPERTIES TAB RANK OCCURENCE IS 3
4)TOP/BOTTOM-- BOTTOM
IN RANK T/F OUTPUT WILL BE AS BELLOW:

RANK INDEX NAME CARDNUMBER
1 A 111111111
2 A 01010101
3 A 34343434
1 B 55555555
1 C 77777777

IN AGGREGATOR
1)CREATE 3 OUTPUT PORT AS credit card,ssn,debit card
2)group by name
3)ssn (o/p)<-
first(decode(rankindex,1,name)
4)credit card(o/p)<-
first(decode(rankindex,2,name)
5)debit card(o/p)<-
first(decode(rankindex,3,name)

output will be
NAME,SSN,CREDIT CARD,DEBIT CARD
A,111111111,01010101,34343434
B,55555555,,
C,77777777,,

THANKS
ABHISHEK GUDDU

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More Informatica Interview Questions

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

how to remove staging area

1 Answers  

How to view and Generate Metadata Reports?

1 Answers  

what is unique constraint error ?

2 Answers   TCS,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

What is a stored procedure transformation?

0 Answers  

scenario

1 Answers  

What are parallel querys and query hints?

1 Answers  

For more Informatica Interview Questions Click Here
Categories