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
- 34841 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rabikant thakur
Please ignore my first ans. i miss to write "not"
Here is currect ans:
Flat file like Notepad,MS-Word Flat file does not maintain
the referential integrity and property like RDBMS and
seprated with some delimeter like
comma and tab
| Is This Answer Correct ? | 21 Yes | 4 No |
Answer / 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 |
Answer / coolboy
Flat file is a normal text file like msword,notepad etc.It
is of 2 types fixed width and delimited flat file.It is no
way related to RDBMS.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
Answer / abhiram
"FLAT FILE IS A FILE HAVING DATA IN DIFFERENT FORMAT"
(OR)
"THE FILE WHICH CONTAINS PARTICULAR STRUCTURE"
TO EXTRACT FLATFILE JUST CLICK.
SOURCE ANALYZER-IMPORT FLAT FILE(i.e.,WE CAN EXTRACT
THE FAT FILE WHICH IS LOCATED IN LOCAL SOURCE DATABASE).
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rabikant thakur
Flat file like Notepad,MS-Word Flat file does maintain the
referential integrity and seprated with some delimeter like
comma and tab
| Is This Answer Correct ? | 10 Yes | 10 No |
Answer / venkadesh
IT IS NOTHING BUT TEXT DOCUMENT SO WE TAKE AS SOURCE FILE.
AFTER THAT WE LOAD IN SOURCE TABLE. BY CLICKING SOURCE MENU
AND SELECT IMPORT FILE
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / venkadesh
IT IS NOTHING BUT TEXT DOCUMENT SO WE TAKE AS SOURCE FILE.
AFTER THAT WE LOAD IN SOURCE TABLE. BY CLICKING SOURCE MENU
AND SELECT IMPORT FILE
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / naresh
flat file is a file which is stored in our local system
which can be of the form .txt etc this should be of fixed
length
| Is This Answer Correct ? | 1 Yes | 5 No |
What are the data movement modes in informatcia?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
how the server recognises , if the session fails after loading the 100 records in to the target
Without using Lookup & Sequence Generator, How to generate Sequence?
What is domain and gateway node?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Explain what are the different types of transformation available in informatica.
when will we go for unconnected lookup transformation in Informatica?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
how the informatica server sorts the strings values in rank transformations?
Teradata 
