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.

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

what is update strategy transformation ?

7 Answers   TCS,

What is depict expression change?

0 Answers  

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

how can we use sorter transformation in joins?

5 Answers   IBM,

what is the size of ur database(like oracle)

2 Answers   HP,

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

What is workflow monitor?

0 Answers  

What is status code?

2 Answers  

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,