Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - At source level I have 40 columns want only 20 cols at target what are the various ways to get it?




609
views
asked mar September 20, 2014 06:32 AM  

At source level I have 40 columns want only 20 cols at target what are the various ways to get it?


           

1 Answers



 
answered By vishnoiprem   0  
  • If source is Database:
  • We have select required 20 columns:
  • select 20 columns in database query.
  • If source is file:
  • Use transformer stage and populate require 20 columns only
  • If source is database or file you can use copy stage insted of transformer and modify.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert