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
in reporting we add some new objects,how we get the count of the newly added objects to the report
Parameter and variable differences
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
What is the need for an etl tool?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Can we override a native sql query within informatica?
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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to update a particular record in target with out running whole workflow?
What is a sorter transformation?
can anyone suggest best free Talend data integration training online
Mention a few design and development best practices for informatica?
How will the document be delivered to me?
Explain scd type 3 through mapping.