Large File Handling

, ,
1

Hi,

Flatfile Ex:

Header
Detail1 (recordWithNoID)
Detail2 (recordWithNoID)
…
DetailN
Summary

flatfile schema created all at the same level

header
recordWithNoIDList(detail)
Summary

when I convert the flatfile to values with teh above mentioned schema the detail data is getting into undefData into Header and have summary is created and no detail

Do I have to create the schema differently?

Any help is greatly appreciated.

Thanks!

2

Hello,

Can you attach sample data?

Thanks,
Anil

3

Hey,

HEADRT101 123420110824124708
08/24/201108/31/201108/31/20110354USDA123
08/24/201108/31/201108/31/20110354USDD123
TRL 1234522.62 1074

I have duped some data here only I have 2 records in the detail whereas in real scenario there will thousands.

As its a large file I need all records/lines ( header,detail(no record identifier ,trial) on the same level.

I am having issues creating the schema such that all records are on same level. was make it do if the detail has record identifier.

Appreciate your time.

Thanks!