at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it

Answer Posted / madhu tallapaneni

Use COPY , MODIFY, Transformer
Coming to performance point of use Modify or Copy stage instead of transformer stage while dealing with huge volume of data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the importance of the exception activity in datastage?

614


What is datastage engine?

721


which r the connectors used in san?

1783


Can you explain engine tier in information server?

644


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3364






How many types of stage?

666


What is the difference between orabulk and bcp stages?

566


How you can fix the truncated data error in datastage?

1184


What are system variables and sequencers in datastage

599


What are the types of views in datastage director?

1235


Define Routines and their types?

616


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

541


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1608


Can you explain repository tables in datastage?

892


Define Data Stage?

628