In case of dbases- time is consumed to make the dbase connection for read

Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar

Question Posted / joe

Answer Posted / joe

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

What is difference between a gateway node and worker node?

1141

What are the mapping parameters and mapping variables?

1205

Enlist the differences between database and data warehouse.

1120

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1954

Describe an informatica powercenter?

1127

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1781

What is the way to execute pl/sql script using informatica mapping?

1606

What is transformation?

1099

What are the settings that you use to configure the joiner transformation?

1055

EXL informatica Questions

1391

Explain sessions and how many types of sessions are there?

1011

Explain how to import oracle sequence into informatica?

1014

Explain lookup transformation in informatica

1073