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
- 5803 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
client know skid info?
What can we do with datastage director?
What is the difference between passive stage and active stage?
What are stage variables and constants?
How do you schedule or monitoring the job?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the types of containers?
How can one find bugs in job sequence?
what is flow of project?
How do you run datastage job from the command line?
What is the different type of jobs in datastage?
Differentiate between Join, Merge and Lookup stage?
Can you explain kafka connector?
Where do the datastage jobs get stored?
Can you explain players in datastage?
