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
- 7436 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 meant by a domain?
What is meant by target load plan?
How many ways are there to do 'remove duplicate records in informatica'?
What is a passive transformation?
Differences between version 7.x and 8.x.
What are roles and groups and benefits of using them?
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
What is sequence generator transformation in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is song in infrmatica...?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is option by which we can run all the sessions in a batch simultaneously?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How do you load alternate records into different tables through mapping flow?
