1)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 / suren
delete the indexes while loading into database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the use of datastage designer?
What are the components of datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Give an idea of system variables.
What are the steps required to kill the job in Datastage?
how to export or import the jobs in .ISX file
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Lookup constraints
How do you import and export the datastage jobs?
Name the different sorting methods in datastage.
Explain datastage architecture?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to abort the job its matain duplicates?
Is it possible to query a hash file?