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 meta stage?

594


Name the command line functions to import and export the DS jobs?

719


how to implement scd2 in datastage 7.5 with lookup stage

5144


Can you explain engine tier in information server?

664


What is the sortmerge collector?

676






Does datastage support slowly changing dimensions ?

667


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3327


What are stage variables and constants?

720


How to reverse the string using SQL?

907


how to export or import the jobs in .ISX file

734


What is the roundrobin collector?

649


What are stage variables?

649


client know skid info?

1638


What is the difference between hashfile and sequential file?

734


How and where you used hash file?

673