Question: what is difference between partitioning of relational target and file targets?
Answer: If you partition a session with a relational target Informatica server creates multiple connections to the target database to write target data concurrently. If you partition a session with file target the Informatica server create one target file for each partition.