Interested to Buy Any Domain ? << Click Here >> for more details...
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 the different kinds of views available in a datastage director?
What are routines in datastage? Enlist various types of routines.
Difference between server jobs & parallel jobs?
What is the difference between operational data stage (ods) and data warehouse?
why do u need the IOS upgradation in a FC switch
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the importance of the exception activity in datastage?
What is active and passive stage?
Can you highlight the main features of ibm infosphere information server?
Give an idea of system variables.
Difference between in process and inter process?
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 to implement scd2 in datastage 7.5 with lookup stage
table actions available in oracle connector?
How can we improve the performance in datastage?
