Archives of the TeradataForum

Message Posted: Tue, 15 Oct 2002 @ 22:10:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

THANX

	<Prev	Next>		<<First	<Prev	Next>	Last>>