Writing into a sequential file in a specific format....

[karrisuresh]

Hi
the source stage is oracle
the target stage is file
all the file have similar records which just vary in first column
Now,
U can use a copy stage to create as many copies as u want followed by a transformer in which u can hard core or use stage variable for the first column in each individual link after the copy stage

If still my answer is not clear,
then I can give an elaborate answer

thanks

hello all,
faced with a new prob

my requirement:
SELECT A,B,C from aaa.

For each row selected, three records are written to the output file. Each one is identical except for the first field in the record. the first field has to be XXX,YYY, ZZZ. my output file is going to look something like this:
for the first record selected,
XXX-11~abc-ddd
YYY-11~abc-ddd
ZZZ-11~abc-ddd

similarly for 2nd, 3ed etc etc..... can i achieve this in DS... ? if not what else should be the aproach?

Thanks in advance!

[karrisuresh]

hello all,
faced with a new prob

my requirement:
SELECT A,B,C from aaa.

For each row selected, three records are written to the output file. Each one is identical except for the first field in the record. the first field has to be XXX,YYY, ZZZ. my output file is going to look something like this:
for the first record selected,
XXX-11~abc-ddd
YYY-11~abc-ddd
ZZZ-11~abc-ddd

similarly for 2nd, 3ed etc etc..... can i achieve this in DS... ? if not what else should be the aproach?

Thanks in advance!

[RakshaPai]

some admin activities going on...
so cannot work on DS for the time being..
will implement all ur suggestions and get back..

thanks all