at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
Answer Posted / jaimy chacko
Use Modify Stage and Drop the columns that are not needed . Or Use a Transformer and take the links tat are only needed(make sure that RCP is not marked )
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is quality stage?
Define Merge?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the difference between account and directory options ?
Where do the datastage jobs get stored?
How many Key we can define in remove duplicate stage?
How we can covert server job to a parallel job?
What is use Array size in datastage
What all the types of jobs you developed?
Can you explain tagbatch restructure operator?
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 are the functionalities of link partitioner and link collector?
Define oconv () and iconv () functions in datastage?
How to read the length of word in unix?
What is the difference between an operational datastage and a data warehouse?