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
- 6242 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 |
How to display errors in datastage?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
how to export or import the jobs in .ISX file
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
What is the difference between operational data stage (ods) and data warehouse?
How complex jobs are implemented in datstage to improve performance?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
How can we do null handling in sequential files
How to get max salary of an organization using data stage stages........... can any body help me plz.......
what is the use of DSattchJob?DetachJob? where can we find it?
How the ipc stage work?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
Teradata 
