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
- 34260 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 |
Can we combine a flatfile and a database table using an UNION transformation?
What is confirmed fact in dataware housing?
Explian the Process of deployment groups in informatica
What is an aggregator transformation?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
if i am having 10 records in source, i want 20 records in target...how will you do it
In dimension and fact table? which one holds big data?
What is Java Transformation? what are the uses of it?
What are the various types of transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
how to call lookup qualifer in unconnected look;up
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Teradata 
