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
RakshaPai wrote: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!