Interested to Buy Any Domain ? << Click Here >> for more details...
What is configuration your file structure 2)I have two
databases both are Oracle while loading data from source to
target the job takes 30 min but I want to load less time how?
- 1 Answers
- 6331 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / subhash
1) configuration file structure:
{
node "node1"
{
fastname "<SERVER_NAME>"
pools ""
resource disk "</dsg/IBM/..DATASETS Path>" {pools
""}
resource scratchdisk "</dsg/..Scratch disk/Buffer
Path>" {pools ""}
}
node "node2"
{
fastname "mctux034"
pools ""
resource disk
"/dsg/IBM/IBM/InformationServer/Server/Datasets" {pools ""}
resource scratchdisk
"/dsg/IBM/IBM/InformationServer/Server/Scratch" {pools ""}
}
}
2)
SRC--->COPY---->TGT
Here Copy stage increase performance and works as a Buffer
when diff in reading count and writing record count.
by setting/checking below in Target ORACLE Connector:
Record Count=6000 (default is 2000, should be multiple of
Array Size)
Array Size=3000 (default is 2000)
Write mode=Bulk Load
Rebuild Indexes After Bulk Load
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to Remove Duplicate using SQL?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between datastage and datastage tx?
What are the main features of datastage?
What are the steps required to kill the job in Datastage?
Define data aggregation?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many types of views are there in a datastage director?
Explain entity, attribute and relationship in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is difference between join, merge and lookup stage?
What is process model?
What are the types of containers in datastage?
Describe the architecture of datastage?
