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
why do u need the IOS upgradation in a FC switch
Differentiate between operational datastage (ods) and data warehouse?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is the sortmerge collector?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Can you explain kafka connector?
What are transforms and what is the differenece between routines and transforms?
Can you highlight the main features of ibm infosphere information server?
What are the types of jobs we have in datastage?
Terminate Activity
How do you schedule or monitoring the job?
What is a datastage job?
How you Implemented SCD Type 1 & Type 2 in your project?
Differentiate between odbc and drs stage?
sed,awk,head