Question { 8250 }

i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like

target1
deptno,sal
1,2000
3,4000
4,5000

target2
2,3000
1,2300
5,1100


with out using transformerstage

Answer

seq1---------seq2


seq1 read the file.

seq2 ----give outfile1 and click on file give outfile2 then partition tab then select roun rabin partition key first column.

get the desired output.

Question { TCS, 42846 }

what is the exact difference between dataset and fileset in
datastage?

Answer

1) dataset in native format so it can view the data only internally(datastage) where as fileset is in binary format so data can be view in any where which is convert from binary to human understandable language.

2) dataset dont support reject link where as fileset support reject link.

3) dataset is copy operator fileset is import and export operator.