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


Please Help Members By Posting Answers For Below Questions

What is quality stage?

661


Define Merge?

984


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

2378


What is the difference between account and directory options ?

718


Where do the datastage jobs get stored?

826






How many Key we can define in remove duplicate stage?

920


How we can covert server job to a parallel job?

683


What is use Array size in datastage

1415


What all the types of jobs you developed?

758


Can you explain tagbatch restructure operator?

805


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 ?

1714


What are the functionalities of link partitioner and link collector?

682


Define oconv () and iconv () functions in datastage?

980


How to read the length of word in unix?

972


What is the difference between an operational datastage and a data warehouse?

734