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
- 34560 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 |
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is the reusable transformation?
Explain direct and indirect flat file loading (source file type) - informatica
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
What is a parameter When and where do you them when does the value will be created
Explain the different dimensions.
what is session override?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
How does the session recovery work.
How can you generate reports in informatica?
why we use datawarehouse
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
Teradata 
