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
- 34230 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 |
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
Define filter transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is difference between COM & DCOM?
What is log file,and where is it located,why u r using the log file
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What is sql query override? When did u use sql query override?
what is the difference between stop and abort
What are the types of metadata that stores in repository?
What is difference between a connected look up and unconnected look up?
what is informatica metadata?
Teradata 
