multiple output files

pavan_test · Post by **pavan_test** » Mon Apr 06, 2009 1:10 pm

Hello,

can anyone please suggest me how do I create output files with multiple record types using px

Thanks
Mark

girija · Post by **girija** » Mon Apr 06, 2009 1:21 pm

"Multiple Rewcord Type" is dyanamic or fixed?

pavan_test · Post by **pavan_test** » Mon Apr 06, 2009 1:31 pm

It is fixed.

girija · Post by **girija** » Mon Apr 06, 2009 1:44 pm

Separate them by using Transformer and create file accordingly.

pavan_test · Post by **pavan_test** » Mon Apr 06, 2009 1:56 pm

Thank You.

For now I need 10 output files. In future if I my client needs 100 files then my design becomes cumbersome.

Is there a way to perform this dynamically.

Thanks
Mark

girija · Post by **girija** » Mon Apr 06, 2009 2:05 pm

We did it using custom build stage (or you can try by buildop stage). I don't think anything available in data stage for dynamic file generator.

pavan_test · Post by **pavan_test** » Mon Apr 06, 2009 2:13 pm

Thank You.

DSguru2B · Post by **DSguru2B** » Mon Apr 06, 2009 2:19 pm

I would introduce a staging table in the middle with two columns, first record identifier and the second, rest of the row. This way it will be dynamic. You can enter records into the table from multiple sources and then pass a select and extract the contents into a file. This way you can have n sources and a single output.