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
What is joiner transformation?
Enlist some properties of sessions.
Which transformation should we use to normalise the COBOL and relational sources?
Explain the etl program with few examples.
What is Index Caches size?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
EXL informatica Questions
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Define sessions in informatica etl?
Differences between connected and unconnected lookup?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to delete duplicate row using informatica?
Explain informatica architecture - version 8 / 9
What is mapplet in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?