Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default execution order of the sequential file?
- 3 Answers
- 13797 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 |
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Which algorithm you used for your hashfile?
how to do pergformence tuning in datastage?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
how can we join one oracle & flat files ?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
How do y read Sequential file from job control?
how to remove duplicates in transformer stage by using stage variables?one example?
How to move data set from one server to other?what are the steps to follow to do this?
How to convert RGB Value to Hexadecimal values in datastage?
How one source columns or rows to be loaded in to two different tables?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Teradata 
