Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.

Answer Posted / raj

Flat file is a text file.give some data in note pad using
delimiter or fixed width. later import it into designer
from source analyzer sources-->import from file.

next declare the properties in session
file directory: give the path(c:\)
file name: emp.txt
under mapping tab for source.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2071


can anyone suggest best free Talend data integration training online

1483


What is joiner transformation?

760


How do you load only null records into target?

953


Explain what are the different versions of informatica?

869


Why union transformation is an active transformation?

858


How to generate or load values in to the target table based on a column value using informatica etl tool.

839


What is complex mapping?

875


Differentiate between sessions and batches?

785


What all join we can perform in LOOKUP transformation?

758


how to load dimension table and fact table. plz tell me the steps.

1877


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

880


what is index?how it can work in informatica

1823


Under what conditions selecting sorted input in aggregator will still not boost session performance?

835


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1562