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
- 5851 Views
- Hexaware, I also Faced
- E-Mail Answers
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 |
Where do you see different stages in the designer?
Describe the main features of datastage?
What is Horizontal transformation, vertical transformation,diagonal transformation?
What are the processing stages?
What is the difference between server job and parallel jobs?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
What is diff between Junk dimensions and conform dimension?
What are the prerequisites for join stage
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
how many rows sorted in sort stage by default in server jobs
how to validate the jobs
Teradata 
