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 meta stage?
Name the command line functions to import and export the DS jobs?
how to implement scd2 in datastage 7.5 with lookup stage
Can you explain engine tier in information server?
What is the sortmerge collector?
Does datastage support slowly changing dimensions ?
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
What are stage variables and constants?
How to reverse the string using SQL?
how to export or import the jobs in .ISX file
What is the roundrobin collector?
What are stage variables?
client know skid info?
What is the difference between hashfile and sequential file?
How and where you used hash file?