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 RD using transformer?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the repository tables in datastage?
What is the difference between an operational datastage and a data warehouse?
What are stage variables?
explain about citrix scheduling tool in datastage
CHANGE CAPTURE
Can you explain tagbatch restructure operator?
What is the difference between operational data stage (ods) and data warehouse?
How a routine is called in datastage job?
How to reverse the string using SQL?
Differentiate between Join, Merge and Lookup stage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the process of killing a job in datastage?
why do u need the IOS upgradation in a FC switch