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

Answer / srinu

The main Data sorces for Informatica,,,

1)Relational Databases,,like(oracle,Teradata,Sql server,,,)

2)Flat File (data in a Notepad(Text format)) in a
Perticular path.



srinu,,,,,

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

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.

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.

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).

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

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

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

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

What are the different types of olap? Give an example?

0 Answers  

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

explain about session partitions ?

1 Answers  

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

What do mean by local and global repository?

0 Answers  

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

What is substr in informatica?

0 Answers  

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

can you use flat file for repository?why?

2 Answers   TCS,

Explain the types of transformations?

0 Answers  

How to recover the standalone session?

2 Answers