1)CFF STAG--------2)TRF-------3)SEQ_FILE
1)a) Please find the parallel schema of the my INPUT CFF STAGE as follows .
Code: Select all
record
{record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, nofix_zero}
(
copy_of_complex_flat_file_39_record_id:string[1] {position=0,link,};
copy_of_complex_flat_file_39_record_type:tagged {reference=copy_of_complex_flat_file_39_record_id,position=0} (
HEADER:subrec {tagcase='0'} (
COLUMN_HDR:string[1];
COLUMN_FILE_VER:string[2];
COLUMN_FNAM:string[8];
COLUMN_CREA_DATE:string[10];
COLUMN_CREA_TIME:string[8];
);
DETAIL:subrec {tagcase='1'} (
COLUMN_DATA:string[1];
COLUMN_LOG_VER_NO:string[2];
COLUMN_APPL_ID:string[8];
COLUMN_PROC_ID:string[30];
COLUMN_LOG_TYP:string[16];
COLUMN_APPL_TRAN_REF:string[30];
COLUMN_LOG_TS:string[26];
COLUMN_LOG_LGTH:decimal[9,0] {link_keep,zoned};
FILLER_2:string[10];
COLUMN_LOG_DATA[max=32600]:subrec {reference='COLUMN_LOG_LGTH'} ( FILLER_3:string[1];);
COLUMN_DELIMITER:string[1];
);
TRAILER:subrec {tagcase='2'} (
COLUMN_TRL:string[1];
COLUMN_REC_CNT:decimal[9,0] {zoned};
);
);
I checked following option
1)b) In CFF stage --> output table --> selection->Enabled all group column section
2) a)In tranformaer stage input side column property on column COLUMN_LOG_DATA --- contains one more propery OCCURS with value 32600
2) b) in Tranformaer stage when I map the column i.e. COLUMN_LOG_DATA to target seqemtial file -- Job aborting with following error
Transformer_46: Error when checking operator: When binding input interface subrec "COLUMN_LOG_DATA" to subrec "COLUMN_LOG_DATA": A variable-length vector is bound to fixed-length vector input.
Query 1:
How to get COLUMN_LOG_DATA (group ) value in target ?
Query 2
I have input data as CFF file occur 4 on the col2
1) input data
column_1 , column_2
1 ,xxxxx
2)CFF stage Output data as follows ( i.e pivote option happening )
column_1 , column_2
1,x
1,x
1,x
1,x'
I would like to read input data as is
1) input data
column_1 , column_2
1 ,xxxxx
2)Output data as follows
column_1 , column_2
1 ,xxxxx
Can you suggest how to achieve this