Answer / sarath

first generate the surrogate key (eg rownum). then using the filter stage give the condition where= (rownum%2=0) to one dataset and rejected to another dataset.
I think this will work.

correct me if im wrong.

Answer / rafi

by using round robin partition with two nodes we can get the solution.

Answer / naveen

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.

Answer / mrvprasad

1)First go to Seq File-->Columns-->Add RowNum column and
2)then go to Properties-->select Options-->select Row Number Column=RowNum (Drop down list select RowNum column)
we will get the sequence Numbers.

first do the link sort for Sal in transformer stage.

and in Transformer stage go to
Constraint: Mod(dslink1.RowNum,2)=0 ---o/p1

and then select otherwise check box or write Mod(dslink1.RowNum,2)=1 --->0/p2

Answer / saran

using filter stage we can get output
in filter stage in where clause write condition like this
where sal in(2000,4000,5000) this to one dataset link
and specify reject link to another dataset

Answer / thippareddy.p

From source copy the data into sets using copy or peak
stage then for each copy stage use remove duplicate stage
with duplicate to retain first and last you will get
desired output.....
Hope thios will help u.......

Define Job control?

0 Answers  

Difference between in process and inter process?

0 Answers  

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

1)Source file contains one record, I want 100 records in target file.

3 Answers  

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

What are the important features of datastage?

0 Answers  

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

Difference between data warehousing and olap?

0 Answers  

what is flow of project?

0 Answers   HSBC, IBM,