TO IGNORE A HEADER IN A FLAT FILE (SENDER) XI

[Former Member]

Developing a solution XI in file-jdbc cenario and

the file is a flat file with header line and various

detail lines. I need to write the jdbc table ignoring

the header line of the flat file. How can We do this?

Someone can help me?

Thanks and regards,

Midervilson.

[Former Member]

Hi Midervilson,

If you are using a content conversion based on key fields in the sender file adapter and if your header and details are differentiated by a key field then you can ignore them in content conversion itself. i.e say if your header is identified by a key field value '1' and details are identified by a key field value '2' then just configure your file content conversion details alone and your header will be automatically ignored.

Otherway you can achive this is using mapping. while mapping do not map your header from source to JDBC structure.

hope this helps...

Regards

Anand

Message was edited by: Anand Torgal

[Former Member]

Hi Anand,

Thanks for your help. We solved the problem configuring the `Documento Offset` for the file adapter.

Thanks and regards,

Midervilson.