In update strategy target table or flat file which gives
more performance ? why?

Answer Posted / nagaraju

flat file is better than relational becoz there is no index concet in flat file

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you find any difficulty while working with flat files as source and target?

669


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1740


What is powercenter on grid?

690


What are roles and groups and benefits of using them?

569


What is the function of aggregator transformation?

574






What is meant by pre and post session shell command?

620


What are the popular informatica products?

648


What are the databases that informatica can connect to windows?

576


tell me the rules and responsblites in our project(my project is development)

1494


Explain where to store informatica rejected data? How to extract the informatica rejected data?

575


What is dimensional table?

617


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1866


What are the various types of transformation?

640


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1866


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

692