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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
can anyone suggest best free Talend data integration training online
What is joiner transformation?
How do you load only null records into target?
Explain what are the different versions of informatica?
Why union transformation is an active transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is complex mapping?
Differentiate between sessions and batches?
What all join we can perform in LOOKUP transformation?
how to load dimension table and fact table. plz tell me the steps.
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?
what is index?how it can work in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?