Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 26 January 2014

issues while working with flat files in Informatica?

By on 04:25:00

· We cannot use SQL override while using flat files as source.

· We need to specify correct path in the session and have to mention the file is ‘direct’ or ‘indirect’.

· And keep the file in exact path as mentioned in the session.

· Have to convert the date field to date data type since it reads as string.


  1. Hi Kashif,
    Thanks for your blog. This question is quite interesting. I believe if you frame this question as (suggestion) "Points to be considered while working with flat files" . Since if we always points the issue around some thing then it would give a fear for new bees. Additional point you can consider as

    1) File name that comes with date and that date should be extracted then use indirect method and take the last string rather than counting from the beginning since in different env, string length is different.

    Please keep writing blogs.
    You can contact me at
    Thanks for your extra time for the blog

    1. Thanks for your valuable comment

  2. > If the flat file is in UNIX system, then you need to manage the dos to unix conversion.
    > Handling the null characters
    > Special characters

  3. when we use 'output field names' the first field name always start with #
    MS office might get error in opening Flat file targets generated by informatica with .xls or .xlsx extension.
    Need to give 'number of initial rows to skip ' in case of flat file sources/lookups

  4. when we give source file directory does the service search for the file in theat directory only or if it does not find it in that directory, it will search in the sub directories too.

    1. It will search in sub directory too.


Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)