How can we improve the performance in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
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 ?
How do you find the number of rows in a sequential file?
where the log files or tables can store in DS?
What is staging variable?
how to identifie,is it innerjoin,leftouter join in lookup?
what is repositery?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
How do you schedule or monitoring the job?
What is RCP?
What are stage variables and constants?
How to delete the data in dataset?types of deleting the data in dataset?
If you want to use a same piece of code in different jobs, how will you achieve this?