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
- 7331 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 |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain pmcmd command usage in informatica
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What differs when we choose the sorted input for aggregator transformation?
what is mapping parameter and mapping variables
Clarify the utilization of aggregator cache record?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Can anyone briefly describe abt audit table loading?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
How to load last 10 records of flat file in to the target?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Teradata 
