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
EXL informatica Questions
How to Create a folder using pmrep command?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Slowly changing dimensions, types and where will you use them
What does refresh system mean, and what are its distinctive choice?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How are indexes created after completing the load process?
Which version configuration tool used in ur project?
Explain joiner transformation in informatica
In informatics server which files are created during the session rums?
without table how to come first record only in oracle?
How to generate sequence numbers without using the sequence generator transformation?
Where can we find the throughput option in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the types of schemas we have in data warehouse and what are the difference between them?