What is the default execution order of the sequential file?
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
Can you highlight the main features of ibm infosphere information server?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What steps should be taken to improve Datastage jobs?
which r the connectors used in san?
What all are the different way to run a job?
How complex jobs are implemented in datstage to improve performance?
Why do you need stage variables?
How do you import and export the datastage jobs?
How to read the length of word in unix?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the difference between in process and inter process?
How do you import and export data into datastage?
What is the sortmerge collector?
What are the different type of jobs in datastage?
client know skid info?