Hi All,

I am trying to create a ff schema.

The structure of the data is:

OrderHeader
OrderLineDetails
OrderLineDetails

OrderHeader
OrderLineDetails
OrderLineDetails
OrderLineDetails

.
.

OrderHeader & OrderLineDetails are records and those contains fields with tab as field separator.

I have created a dictionary which contains all the fields and then created two records(OrderHeader & OrderLineDetails). And I am using these two records as references in the flatfile schema. But when i send my input file I am not getting in the expected format.

Please suggest me how to develop the flat file schema for the above mentioned structure.

Thanks in advance…!

Regards,
C J Nageswara Rao

Hello,

Can you attach sample file.

Thank you,
Anil

Here I am attaching the sample doc.

Please suggest me how to develop the flatfile schema for that…!

Thanks in advance.

Regards,
C J Nageswara Rao
sample.txt (753 Bytes)

What are you expecting ?