Archives of the TeradataForum
Message Posted: Tue, 15 Oct 2002 @ 22:10:55 GMT
<-- Anonymously Posted: Tuesday, October 15, 2002 09:16 -->
I have Following needs and need a expert advice.
Receive text files Three tables will be populated File_Name PK_FN_ID, ............. HDRTRL PK_HDRTRL_ID, FK_FN_ID, ......... REC9201 FK_HDRTRL_ID, DUP and Details
For each pack there would be header and trailer and between them there would be detail records
First we need to make sure that each header has got matching trailor. Detail records will be within header and trailor
One file can have multiple packs
We need to populate PK's and FK's as well as DUP flag if record is duplicate This dup can reside anywhere in the pack.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|