Interested to Buy Any Domain ? << Click Here >> for more details...
what is the flat file partition and where have to specify it
- 1 Answers
- 7622 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Which gives the more performance when compare to fixed width and delimited file ? and why?
what is a time dimension? give an example?
What is the Process to creating lookup transformation in informatica
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
have u done any performance tuning? how u ll do?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what happens if you try to create a shortcut to a non- shared folder?
What is tracing level and what are the types of tracing level?
can any one explain me about junk dimension
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Teradata 
