Answer / rayudu

One more thing is while loading the data into table
,informatica writes the data into database logs before
loading into target ,and this cant be done while loading a
flat file.

Answer / rayudu

hi,


Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.



Regards,
rayudu.

Answer / joe

In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.

Answer / rayudu

another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.

Answer / ranjan

One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.

Answer / suresh

Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.

But where as records from flat files are copied in easier way

Answer / nidhi

To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.

Answer / ankur saini er.ankur861@gmail.

Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.

Answer / sanjay

While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.

Answer / manojkumar

Thanks Rayudu.

Is there any other reson why flat file load is faster than
table load.

I had an interview and even I said the same answer. But the
interviewer asked me "Is there any other reason ?" .
Interviewer didn't satisfied with this answer.

I hope there will be some other reason as well for this
question.
Anyways thanks for your reply.

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

how we load the data from source to staging area

4 Answers   TCS,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

define galaxy repository in informatica

0 Answers  

Why we need XMLs?

3 Answers   IBM,

Define filter transformation?

0 Answers  

Define sessions in informatica etl?

0 Answers  

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

What is meant by a domain?

0 Answers