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 types of maping in Getting Started Wizard?

1 Answers  

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

How to use pmcmd utility command?

0 Answers  

why we are using surogate key in real time give me explanation

2 Answers   TCS,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

How can you define user defied event?

0 Answers  

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

What is junk dimention?

3 Answers   Patni,