Do you find any difficulty while working with flat files as source and target?

devquora
devquora

Posted On: Nov 08, 2022

 

Yes, there are difficulties I found while working with flat files some of them are:

  1. We can’t use SQL override in flat files instead of that we have to use transformations.
  2. testing the flat files is a very uninteresting job
  3. We need to specify the correct path in the session and mention whether that file is ‘direct’ or ‘indirect. Keep that file in the exact path which we have specified in the session and we have to keep the file in the exact path as mentioned in the session.
  4. If we miss the link to any column of the target, then all the data will be placed in the wrong fields. That missed column won’t exist in the target data file.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Informatica Interview Questions

    In warehouses how many schemas are there?

    There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema..

    Informatica Interview Questions

    Could you explain what is Enterprise data warehouse?

    In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

    Informatica Interview Questions

    What is different between the data warehouse and data mart?

    A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales..