Informaticans

All about Informatica

Informatica – Flat File tips

Flat Files
1.      Use Informatica’s capabilities for Extracting from multiple sources. Using proprietary tools (like SQL*Loader) is not advisable if there are multiple sources as there would be multiple environments and dependencies.  If we are dealing with very huge flat files then usage of such tools is encouraged, as these would be effective in bulk loads.
2.      The Source and Target flat files should be stored in the Informatica Server
3.      The source flat files always need to be de-limited. The recommended delimiter is a combination of wild characters like #$#$.
4.      Implement process at the source to PUSH the files into the server
5.      Whenever extracting data from Flat Files, implement the logic at the Data Staging Area level, rather than at the Source Level.

Flat Files usage & Tips:

1.      Use Informatica’s capabilities for Extracting from multiple sources. Using proprietary tools (like SQL*Loader) is not advisable if there are multiple sources as there would be multiple environments and dependencies.  If we are dealing with very huge flat files then usage of such tools is encouraged, as these would be effective in bulk loads.

2.      The Source and Target flat files should be stored in the Informatica Server

3.      The source flat files always need to be de-limited. The recommended delimiter is a combination of wild characters like #$#$.

4.      Implement process at the source to PUSH the files into the server

5.      Whenever extracting data from Flat Files, implement the logic at the Data Staging Area level, rather than at the Source Level.

Comments (0)

  • No comments yet.