what is the flat file partition and where have to specify it
Answer / 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 |
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
What are the mapping parameters and mapping variables?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
what is junk dimension
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What are the different types of Type2 dimension maping?
Why we use lookup transformations?
Enlist the advantages of informatica.
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
What is synonym?