Write Hierarchial file using Fast export

Tools
Fan

Write Hierarchial file using Fast export

Hi All,

I would like to know if there is a way to write a hierarchial file using fast export utility.

For ex, lets assume we have 5 levels of hierarchy. (L1, L2, L3, L4, L5).

And let's assume L1 can have two L2's, three L3's, 1 L4 and 1 L5. 

Individually all these levels mentioned are a table.

Assuming, there are two records at L1 level. The fast export file should write something like

L1 (1)

L2 (Record corresponding to L1(1))

L2 (Record corresponding to L1(1))

L3 (Record corresponding to L1(1))

L3 (Record corresponding to L1(1))

L3 (Record corresponding to L1(1))

L4 (Record corresponding to L1(1))

L5 (Record corresponding to L1(1))

L1 (2)

L2 (Record corresponding to L1(2))

L2 (Record corresponding to L1(2))

L3 (Record corresponding to L1(2))

L3 (Record corresponding to L1(2))

L3 (Record corresponding to L1(2))

L4 (Record corresponding to L1(2))

L5 (Record corresponding to L1(2))


Is possible to write such a hierarchial file using fast export. Appreciate if anyone could provide some pointers.

2 REPLIES
Enthusiast

Re: Write Hierarchial file using Fast export

To be more clear, maybe you can provide an example, because it may be misleading.

I feel a combination of fastexport with unix scripting may help here.

The word hierarchical, looks like you have xml, json, geojson.... formats...

Teradata Employee

Re: Write Hierarchial file using Fast export

The basic answer to the question is "no".

The record formats are explicitly documented in the FastExport manual and hierarchical records are not supported.

-- SteveF