Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default execution order of the sequential file?
- 3 Answers
- 13952 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 |
on how many columns we can perform aggregation in the Aggregator stage?
How many jobs in ur project? Explain any complex job u have done in ur project?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
CHANGE CAPTURE
what is factless fact table?
What are the types of views in datastage director?
To see hidden files in LINIX?
How to add zero "0" before record in a field?
Describe routines in datastage? Enlist various types of routines.
What is audit table?
Teradata 
