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 Index Caches size?
What is the difference between stop and abort in informatica
During the running session, output files are created by informatica server. Enlist few of them.
what is the complex transformation you used in informatica
what is the size of u r source(like file or table)?
Explain what are the different versions of informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is workflow monitor?
What is the use of an aggregator cache file?
What is the status code in stored procedure transformation?
How to load a Dimension ? and how to load a fact table?
What is intricate mapping?
What is the need for an etl tool?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,