what is the diff between sequential file and fileset stages?
- 3 Answers
- 25713 Views
- I also Faced
- E-Mail Answers
Answer Posted / venugopal [patni]
Sequential file is used to read the data sequentially.
It can be configured to execute both in parallel and
sequential mode.We cann't perform lookups using sequential
file.
Fileset stage is used to import the exported files list.
It executes only in parallel mode.
the most importance of it is 2G.B limit on the size of a
file and we need to distribute files among the nodes to
prevent overruns.
| Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
What is merge stage?
Explain how a source file is populated?
What is the flow of loading data into fact & dimensional tables?
Is it possible to query a hash file?
What is the difference between validated and compiled in the datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Difference between server jobs & parallel jobs?
Why we use surrogate key?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
how to sort two columns in single job in datastage.
What is oci?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do y read Sequential file from job control?
Differentiate between datastage and informatica?
