Interested to Buy Any Domain ? << Click Here >> for more details...
i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
- 5 Answers
- 14160 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
1) In sequential stage we have stage properties on that
select options and increase the readers
2) In datastage admin we have on environmental variable like
logical reader that set as one
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you filter data in hashed file?
explain about citrix scheduling tool in datastage
What are stage variables, derivations and constants?
Which algorithm you used for your hashfile?
What are stage variables?
What is the use of datastage director?
Differentiate between Join, Merge and Lookup stage?
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 ?
Difference between sequential file and data set?
What is active and passive stage?
What are the different options associated with dsjob command?
What is ds designer?
How many Key we can define in remove duplicate stage?
How one source columns or rows to be loaded in to two different tables?
Lookup constraints
