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
- 6843 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
what is the size of u r source(like file or table)?
How does the aggregator transformation handle null values?
Why filter transformation is an active one?
How to do the error handling of if ur source is flatfiles?
What is aggregator transformation in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How many ways are there to do 'remove duplicate records in informatica'?
Explian the Process of deployment groups in informatica
scenario where i can use only concurrent execution of workflow.
What is the difference between a repository server and a powerhouse?
wat are deployement groups in informatica, how it will be used for developers
What does “tail –f” command do and what is its use as an Informatica admin.
In development project what is the process to follow for an etl developer from day1
What is target load order?
How can you increase the performance in joiner transformation?
