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
How can a transformation be made reusable?
What is meant by lookup transformation?
What is domain in terms of informatica?
what are 3 tech challenges/ common issues you face?
How to create or import flat file definition in to the warehouse designer?
What is data transformation manager process?
What can we do to improve the performance of informatica aggregator transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Briefly define a session task?
can u give example for factless fact table
Explain sessions?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Design time, run time. If you don't create parameter what will happen
What happens to map if we alter the datatypes between source and its corresponding source qualifier?