Functional Map to combine 3 input cards based on unique data
Posted: Tue Nov 16, 2010 5:57 am
I am a newbie and I found this forum through Wikepedia while searching for books on WTX/Datastage TX. I am using WTX 8.2 and need help/pointers for my requirement.
I need to create an output using 3 files that are linked.
File 1:
ACCTNO,FUTUR3,ACTTRM,SNTDTE,DELFLG,DELDTE
File 2:
ACCTNO,FUTUR3,ACTTRM,LDUDTE,LMBAMT,SERCH,INVNO,LFBAMT,PSTDUE,SNTDTE
File 3:
ACCTNO,FUTUR3,ACTTRM,EFFDTE,CDDESC,ENDDTE,BILAD1,BILAD2
I need to flatten the records for each combination of ACCTNO,FUTUR3,ACTTRM
What I understood is that I need to use a function map that does a 'lookup' of ACCTNO,FUTUR3,ACTTRM.
Could anyone advice me on how to proceed? If required, can upload file content.
Thanks
I need to create an output using 3 files that are linked.
File 1:
ACCTNO,FUTUR3,ACTTRM,SNTDTE,DELFLG,DELDTE
File 2:
ACCTNO,FUTUR3,ACTTRM,LDUDTE,LMBAMT,SERCH,INVNO,LFBAMT,PSTDUE,SNTDTE
File 3:
ACCTNO,FUTUR3,ACTTRM,EFFDTE,CDDESC,ENDDTE,BILAD1,BILAD2
I need to flatten the records for each combination of ACCTNO,FUTUR3,ACTTRM
What I understood is that I need to use a function map that does a 'lookup' of ACCTNO,FUTUR3,ACTTRM.
Could anyone advice me on how to proceed? If required, can upload file content.
Thanks