What is the default execution order of the sequential file?
Answers were Sorted based on User's Feedback
Answer / srinivas
By default it is sequential but we can make it as parallel.
By defying the number of readers per node option.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / dipanjan17
The execution mode of Sequential file stage in datastage is
sequential by default.You can validate that from :
Sequential file stage--->Stage tab-->advanced tab ---
>Execution Mode
Is This Answer Correct ? | 6 Yes | 1 No |
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 |
What are the environmental settings for data stage,while working on parellel jobs?
how to handle null values using transformer stage?
State the difference between an operational datastage and a data warehouse?
how to handle null values in sequential file?
i have the source from Uk,north america how can i pass the data two tables based on the locations
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
what is parameterset?
What are the important features of datastage?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
source contains 2 columns comes to target 4 columns how