INTERVIEW QUESTIONS
DATA WAREHOUSING
INFORMATICA
DETAILS
Question: What is difference between partioning of relatonal target and partitioning of file targets?
Answer: If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u 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.
|