Answer Posted / chiranjeevi.a
To over come the limitation of sequential file,espesially
sequential file: By default reads and writes sequentially
>memory limit is up to 2GB
>conversion is needed
>sourse stores the data out side of datastage
Data file:
>parallel process
>memory is unlimited
>No conversion is needed while reading the data(its
basically in native format).
>stores data inside the repositary
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
how do u catch bad rows from OCI stage? And what CLI stands for?
table actions available in oracle connector?
How you can fix the truncated data error in datastage?
Describe the main features of datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is staging variable?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the functionalities of link partitioner?
What are datastage sequences?
Define oconv () and iconv () functions in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
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 perform incremental load in datastage?