Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default execution order of the sequential file?
- 3 Answers
- 13947 Views
- I also Faced
- E-Mail Answers
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 |
how to handle null values in sequential file?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
How we can convert rows to columns in datastage?
Is there any possibility to generate alphanumeric surrogate key?
root tree will find which is server job and which is parallel job?
DataStage Scenario based Interview Questions
What is the Difference Between DataStage 7.5 version and 8.1 Version?
What is the importance of the exception activity in datastage?
which dim, fact tables used in bank domain
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
what is the difference between the join and look up explin me one exmple
Main Function of the Staging area in DWH ?
Teradata 
