Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
- 10 Answers
- 34521 Views
- CSC, I also Faced
- E-Mail Answers
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
can u any challenge your project?
difference between repository database and repository service?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Can we get 1st record through Informatica(without sequence number).
What is a router transformation?
What is informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
What is difference between a gateway node and worker node?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is substr in informatica?
How do you load first and last records into target table?
Enterprise data warehouse your projects phase by phase explain?
How might one distinguish in the case of mapping is right or not without associating session?
What is source qualifier transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
