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
Terminate Activity
Can you filter data in hashed file?
Why do we use link partitioner and link collector in datastage?
which r the connectors used in san?
What are the functionalities of link partitioner and link collector?
Triggers,VIEW,Procedures
What are data elements?
describe the Steps to confiure a Qlogic switch
Describe the architecture of datastage?
what is ds administrator used for?
Can you explain tagbatch restructure operator?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What all are the different way to run a job?
Notification Activity
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.