at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
Answer Posted / balaji
Using transformation stage
How t o use:
Double click transformation stage
Select 20 columns
Drag and drop there target links.
Click on Ok
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
Have you used Unstructured data?
How to implement complex jobs in data stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is orabulk stage?
Is the value of staging variable stored temporarily or permanently?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the types of containers in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How a server job can be converted to a parallel job?
what is the use of materialized view?
How do you register plug-ins?
What are the features of datastage flow designer?
how can we create rank using datastage?what is the meaning of rank?
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