Page 1 of 1
multiple output files
Posted: Mon Apr 06, 2009 1:10 pm
by pavan_test
Hello,
can anyone please suggest me how do I create output files with multiple record types using px
Thanks
Mark
Posted: Mon Apr 06, 2009 1:21 pm
by girija
"Multiple Rewcord Type" is dyanamic or fixed?
multiple output files
Posted: Mon Apr 06, 2009 1:31 pm
by pavan_test
It is fixed.
Posted: Mon Apr 06, 2009 1:44 pm
by girija
Separate them by using Transformer and create file accordingly.
multiple output files
Posted: Mon Apr 06, 2009 1:56 pm
by pavan_test
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
Posted: Mon Apr 06, 2009 2:05 pm
by girija
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.
multiple output files
Posted: Mon Apr 06, 2009 2:13 pm
by pavan_test
Thank You.
Posted: Mon Apr 06, 2009 2:19 pm
by DSguru2B
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.