Hi in case of teradata..IS have to take care of database logs , and backu

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

Advance Thanks,
Manojkumar

Question Posted / ankur saini er.ankur861@gmail.

11 Answers
18893 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the different lookup cache(s)?

1076

What is a repository? And how to add it in an informatica client?

1128

explan ur project architecture?

2045

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2378

How can we delete duplicate rows from flat files?

1204

Separate from an archive server and a powerhouse?

943

Explain lookup transformation in informatica

1049

What are the popular informatica products?

1001

What is blocking transformation?

1126

Design a mapping to load a target table with the following values from the above source?

1327

what is Active lock explain

2773

what is the complex transformation you used in informatica

2579

What do you mean by filter transformation?

938

how to load dimension table and fact table. plz tell me the steps.

2084

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7016