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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How can we improve the performance in datastage?
What are data elements?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the different plug-ins stages used in your projects?
Nls stands for what in datastage?
What is the purpose of pivot stage and types of containers in datastage
Where do the datastage jobs get stored?
What is the difference between in process and inter process?
What are datastage sequences?
What are the functionalities of link partitioner?
table actions available in oracle connector?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the difference between operational data stage (ods) and data warehouse?