Answer Posted / sagar
When you use sequential file as Source,at the time of
compilation it will convert to native format from
ASCII.where as,when you go for using datasets... conversion
is not required.Also, by default sequenctila files we be
processed in sequenc only.sequential files can accommodate
up to 2GB only.sequentila files does not support NULL
values....all the above can me overcome using dataset
stage....but selection is depeneds on the
requirement....suppose if you want to capture rejected
data....in that case you need to use sequential file or
fileset stage....
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
What are stage variables and constants?
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?
What is orabulk stage?
Name the third party tools that can be used in datastage?
What is a quality stage in datastage tool?
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 the purpose of interprocessor stage in server jobs?
What are the areas of application?
What are the functionalities of link collector?
What is the importance of the exception activity in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How many types of views are there in a datastage director?
What are the primary usages of datastage tool?
Different ways a project can be moved to production ?...example ….export-import and Version control.