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 is 'reconsideration error' and how can i respond to this error and how to debug this
What are orabulk and bcp stages?
AGGREGATOR default datatype
How do you run datastage job from the command line?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How will you move hashed file from one location to another location?
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 are the types of jobs we have in datastage?
Which commands are used to import and export the datastage jobs?
What are stage variables and constants?
how to write server Routine coding?
What are the benefits of datastage?
How a server job can be converted to a parallel job?
What are transforms and what is the differenece between routines and transforms?
What a datastage macro?
