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
- 34224 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
What are the limitations of joiner transformation?
Explain what are the different versions of informatica?
Explain in detail scd type 2 through mapping.
whats the logic to load the lower level of granularity of data to fact table.
What is a joiner transformation?
What is the difference between router and filter?
What is a rank transform?
How can repository reports be accessed without sql or other transformations?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is joiner transformation in informatica?
Define the various join types of joiner transformation?
What are the types of schemas we have in data warehouse.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
how many types of dimensions are available in informatica?
Explain about cumulative Sum or moving sum?
