Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 7427 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How we can create indexes after completing the load process?
Do you find any difficulty while working with flat files as source and target?
Is it possible to use a client with different version than that of its Informatica server?
Explain sessions. Explain how batches are used to combine executions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Slowly changing dimensions, types and where will you use them
What is the use of an aggregator cache file?
Explain informatica architecture - version 8 / 9
Is there any target staging area in informatica not staging area
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is informatica metadata?
How to do unit testing in informatica? How to load data in informatica ?
What is the meaning of up gradation of repository?
What is the difference between router and filter?
What are the different types of olap? Give an example?
