Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
Answer Posted / nagesh
Actually, as said we import data into informatica from
Relational Database sources as well as from Flat File
sources.
A Flat file is a Text file having the data in a different
manner than in the Table.
The data in a Flat file(can be MS Word Doc or Notepad or
any text doc) will be in the form of Fixed width or
Delimited.
Eg of Flatfile
Barak Obama,17,Washington DC,USA OR
01000ScrewDriver009.50{This is fixed
01001Hammer012.95 { width file
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
where to store informatica rejected data?
What are different types of transformations available in informatica?
What is a difference between complete, stop and abort?
What could be the possible resons of locks by user?
what is INFORMATICA TESTING process
Why do we need informatica?
Describe data concatenation?
What is status code in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How can you differentiate between powercenter and power map?
What is union transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
explain about unit testing? in real time?