What is the default execution order of the sequential file?
- 3 Answers
- 12114 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 |
what is the differeces between hash and modulus partition methods
State the difference between an operational datastage and a data warehouse?
how will u design file watch jobs?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
Differentiate between datastage and informatica?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define oconv () and iconv () functions in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
Teradata 
