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
How many input parameters can exist in an unconnected lookup?
What the difference is between a database, a data warehouse and a data mart?
What are the new features of informatica 9.x developer?
What are batches?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the types of lookup transformation?
How to go to the older version for a mapping?
What is the format of informatica objects in a repository?
What is the use of code page?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Could you explain what is enterprise data warehouse?
Enlist the various types of transformations.
Does an informatica transformation support only aggregate expressions?
difference between repository database and repository service?