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

in reporting we add some new objects,how we get the count of the newly added objects to the report

1983


Parameter and variable differences

1841


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9452


What is the need for an etl tool?

840


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5703


Can we override a native sql query within informatica?

826


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1895


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

853


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1860


How to update a particular record in target with out running whole workflow?

1359


What is a sorter transformation?

884


can anyone suggest best free Talend data integration training online

1483


Mention a few design and development best practices for informatica?

751


How will the document be delivered to me?

824


Explain scd type 3 through mapping.

771