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
Where do the datastage jobs get stored?
Explain ibm infosphere information server and highlight its main features?
What is the difference between informatica and datastage?
Difference between in process and inter process?
Differentiate between hash file and sequential file?
What are some different alternative commands associated with "dsjob"?
Describe link sort?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
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
What is a quality stage in datastage tool?
Can you filter data in hashed file?
Define orabulk and bcp stages?
What are the different common services in datastage?
Explain datastage architecture?
Difference between ‘validated ok’ and ‘compiled’ in data stage?