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
- 7349 Views
- Amdocs, I also Faced
- E-Mail Answers
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 |
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What are the issues you have faced in your project? How did you overcome those issues?
what are factless facts? And in which scenario will you use such kinds of fact tables.
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What is synonym?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
how to load dimension table and fact table. plz tell me the steps.
Different types of Power center errors?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How big was your fact table
Teradata 
