top button
Flag Notify
Site Registration

What is difference between portioning of relational target and partitioning of file targets?

+1 vote
223 views
What is difference between portioning of relational target and partitioning of file targets?
posted May 12, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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 a file target the informatica server creates one target file for each partition.U can configure session properties to merge these target files.

answer May 12, 2015 by Manikandan J
Similar Questions
+1 vote

When you create a Lookup transformation using a relational table as a lookup source, you can connect to the lookup source using ODBC and import the table definition as the structure for the Lookup transformation.
where as When you create a Lookup transformation using a flat file as a lookup source, select a flat file definition in the repository or import the source when you create the transformation. When you import a flat file lookup source, the Designer invokes the Flat File Wizard.

I found an interesting article on this topic at below links , It quite descriptive

http://www.tecktricks.com/difference-between-relational-lookup-and-flat-file-lookup-transformation-in-informatica/

...