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
Why do you use Mapping Parameter and mapping variable?
How to partition the Session?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Differences between connected and unconnected lookup?
Explain why we use partitioning the session in informatica?
Why sorter is an active transformation?
What is joiner change?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is mapplet in informatica?
have u done any performance tuning? how u ll do?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain about cumulative Sum or moving sum?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can we create a Integration service without a Repository service and vice versa?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks