What is the procedure for processing a flat file with fixed length layout?

devquora
devquora

Posted On: Feb 22, 2018

 

A layout of the file with fixed length ought to incorporate the record name, where the field starts; its length; and its information type (typically content or number). In some cases, the end position is provided, while for cases when that it is not provided, you need to figure the end position of each field dependent on its starting position and length in the event that it is required by your ETL instrument.

In most ETL apparatuses, you in all likelihood need to physically enter the document format of the level record once. After the design is entered, the apparatus recalls the format and expects that equivalent format each time it interfaces with the genuine level record. On the off chance that the document design changes or the information move off its appointed positions, the ETL procedure must be modified to fall flat.

When preparing fixed length level documents, endeavor to approve that the places of the information in the record are exact. A fast check to approve the positions is to test any date (or time) field to ensure it is a substantial date. On the off chance that the positions are moved, the date field in all likelihood contains alpha characters or unreasonable numbers. Different fields with unmistakable spaces can be tried similarly. XML offers increasingly solid approval capacities. On the off chance that information approval or consistency is an issue, endeavor to persuade the information supplier to convey the information in XML design.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    ETL Testing Interview Questions

    What are the testing procedures included in ETL?

    The various testing procedures included in ETL include the following:..

    ETL Testing Interview Questions

    Explain the three-level hierarchy of a typical ETL cycle.

    The typical three-level hierarchy of an ETL cycle is composed of the following:..

    ETL Testing Interview Questions

    What do you understand by the terms initial load and full load?

    In ETL, the initial load is the procedure for populating all information warehousing tables for the absolute first time...