What is the default execution order of the sequential file?
- 3 Answers
- 12921 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
How to reverse the string using SQL?
whom do you report?
Why do you need stage variables?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the command line function to import and export the ds jobs?
What are the different types of lookups in datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is a merge?
What are the areas of application?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are system variables and sequencers in datastage
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What is a ds designer?
