Multiple output links in Query Transform with different schema

[Former Member]

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)

Query(10 columns)--

                                 |-------File format 2(2 columns)

Is it can be achieved using single Query Transform? If not, kindly suggest how it can be done?

Thanks

[Former Member · Accepted solution]

Hi Raja,

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.

Regards,

Gokul

[Former Member · Accepted solution]

Thanks Gokul.It worked.