Multiple output links in Query Transform with different schema
I need to have two output links from Query Transform written to Flat file with different column structure.
Say for instance, I want to take only selected to two different links.
-->Output link 1 should have 3 column
-->Output link 2 should have 2 column
|-------File format 1(3 columns)
|-------File format 2(2 columns)
Is it can be achieved using single Query Transform? If not, kindly suggest how it can be done?
Take 2 query transform,
1st Query transform - Map the 3 columns you want in output.
2nd Query transform - Map the 2 columns you want in output.