In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / sanjay
Flate file give better performance bcz Retrival of data
from flat file is fast then relation database
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
explain one complex mapping with logic? sales project?
What is the scenario which compels informatica server to reject files?
What is joiner change?
What is lookup transformation?
What is decode in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Different sorts of metadata that stores in the storage facility?
Differentiate between router and filter transformation?
What is meant by pre and post session shell command?
How can you increase the performance in joiner transformation?
How does the aggregator transformation handle null values?
Explain dynamic target flat file name generation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Mention few advantages of router transformation over filter transformation.