what is the flat file partition and where have to specify it
Answer Posted / prabhu
After you tune the application, databases, and system for
maximum single-partition performance, you may find that the
system is under-utilized. At this point, you can configure
the session to have two or more partitions.
You can use pipeline partitioning to improve session
performance. Increasing the number of partitions or
partition points increases the number of threads.
Therefore, increasing the number of partitions or partition
points also increases the load on the nodes in the
Integration Service. If the Integration Service node or
nodes contain ample CPU bandwidth, processing rows of data
in a session concurrently can increase session performance.
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is dynamic cache?
Explain lookup transformation source types in informatica
What is meant by lookup transformation?
Mention a few design and development best practices for informatica?
What is the need for an etl tool?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Differentiate between Load Manager and DTM?
How can you generate reports in informatica?
What is fact table? Explain the different kinds of facts.
What is the sequence generator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
explan ur project architecture?
What is resilience time?
What is workflow monitor?