What is difference between partioning of relatonal target
and partitioning of file targets?

Answer Posted / swetha

If you parttion a session with a relational target
informatica server creates multiple connections o the
target database to write target data concurently.If you
partition a session with a file target the informatica
server creates one target file for each partition. yoU can
configure session properties to merge these target files.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you use sql override in a lookup transformation?

814


explain abt ur project architecture?

1951


Under which circumstances, informatica server creates reject files?

856


How can you define user defied event?

843


What is a router transformation?

856


How to start a workflow using pmcmd command?

959


What is confirmed fact in dataware housing?

6279


Suppose we do not group by on any ports of the aggregator what will be the output?

842


What is the difference between a repository server and a powerhouse?

1191


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

920


What is Index Caches size?

867


What is an expression transformation in informatica?

783


Sequence generator, when you move from develoment to production how will you reset

1685


How can a transformation be made reusable?

877


What is Cognos script editor?

3977