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?
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
How to find value from a column in a dataset?
How can we improve the performance in datastage?
How one source columns or rows to be loaded in to two different tables?
Highlight the main features of datastage?
What is orabulk stage?
What is aggtorec restructure operator?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the purpose of pivot stage and types of containers in datastage
How we can covert server job to a parallel job?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Can you explain repository tables in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is meta stage?
Explain the importance of surrogate key in data warehousing?