Hi All ,
We have nearly 1000 copy books . we import all copy books manually .
Could you please provide suggestion to automate the below process.
1. Flattening
2. Schema generating from flattened table definition as below.
Sample Schema file :
record
{final_delim=end, record_delim='\n', delim=',', quote=double}
(
CNTRLNO:decimal[16,0] {packed, default=0, quote=none};
SFFXNO:int16 {binary, big_endian, default=0, quote=none};
USERID:string[64];
FILLER:string[1834];
)
Thanks in Advance,
Manoj
Create schema files from Metadata Repositry
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI