Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default execution order of the sequential file?
- 3 Answers
- 13565 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
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 |
Post New Answer View All Answers
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How many types of sorting methods are available in datastage?
What are orabulk and bcp stages?
How and where you used hash file?
What is the differentiate between data file and descriptor file?
What is a merge in datastage?
Explain how a source file is populated?
What is the difference between account and directory options ?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How we can covert server job to a parallel job?
Define oconv () and iconv () functions in datastage?
How many types of stage?
Name the different types of Lookups in Datastage?
Can you explain kafka connector?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
