Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default execution order of the sequential file?
- 3 Answers
- 13778 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
It behaves different w r t reading capability.
i.e.,
when it is reading a single file; it does sequential mode of
reading by default and when it is reading multiple files it
does parallel mode of reading by default.
And if we need to improve performance of sequential file
stage when reading a single large file then we have two
options:
1. Read from Multiple Nodes
2. No of readers per node.
1st one is applicable only when flat file is Fixed length
file and not applicable for delimited formatted files.
The latter one is applicable for delimited files by
mentioning no of nodes then it performs parallel mode of
execution by reading single file in partitions improving the
performance.
Thats it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
AGGREGATOR default datatype
what is repositery?
Where do the datastage jobs get stored?
Differentiate between Join, Merge and Lookup stage?
Name the different sorting methods in datastage.
Describe link sort?
What are the types of jobs we have in datastage?
Can you explain tagbatch restructure operator?
What are the types of containers in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the difference types of stages?
What steps should be taken to improve Datastage jobs?
What is a folder? Difference types of stages?
Define oconv () and iconv () functions in datastage?
Explain the situation where you have applied SCD in your project?
