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
What is the difference between operational data stage (ods) and data warehouse?
Explain the importance of surrogate key in data warehousing?
EXPLAIN SCD
What is the importance of the exception activity in datastage?
What steps should be taken to improve Datastage jobs?
What is "fatal error/rdbms code 3996" error?
Could anyone give brief explanation bout datastage admin
What are iconv and oconv?
Differentiate between hash file and sequential file?
What is meta stage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Differentiate between Join, Merge and Lookup stage?
What is the difference between validated and compiled in the datastage?
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 materialized view?