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
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?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Is possible to create skid in dim,fact tables?
Where do you see different stages in the designer?
What is the difference between an operational datastage and a data warehouse?
What is the difference between the local container and shared container?
What is a merge in datastage?
What could be a data source system?
What is apt_config in datastage?
whom do you report?
what is use of SDR function?
What are iconv and oconv?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Differentiate between datastage and informatica?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?