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
- 6309 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
What is the differentiate between data file and descriptor file?
Notification Activity
What are transforms and what is the differenece between routines and transforms?
What are orabulk and bcp stages?
CHANGE CAPTURE
What are the types of containers?
What are the benefits of datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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 many types of hash files are there?
What is the purpose of pivot stage?
What is the roundrobin collector?
What is the sortmerge collector?
How to find value from a column in a dataset?
what is the use of skid in reporting?
