flat file bcz no connections needed no network busy etc;

While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?

Question Posted / krish

Answer Posted / krish

flat file
bcz no connections needed no network busy etc;

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1845

What are the differences between source qualifier and joiner transformation?

1137

What do you mean by filter transformation?

1003

What are the main issues while working with flat files as source and as targets ?

1216

What are the advantages of using informatica as an etl tool over teradata?

1073

what is INFORMATICA TESTING process

2334

generate date / time dimension in informatica

1160

Why update strategy and union transformations are active? Explain with examples.

1284

Explain why we use partitioning the session in informatica?

1162

What do you mean incremental aggregation?

1129

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

What is aggregate cache in aggregator transformation?

1201

without table how to come first record only in oracle?

2301

explan ur project architecture?

2126

What is joiner transformation?

1067