1)First go to Seq File-->Columns-->Add RowNum column and 2)then go

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

Question Posted / mrvprasad

6 Answers
9963 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between datastage and informatica?

1062

What is quality stage?

938

How many Key we can define in remove duplicate stage?

1315

sed,awk,head

1411

Define orabulk and bcp stages?

1069

What is oci?

1260

How do you generate sequence number in datastage?

1027

describe the Steps to confiure a Qlogic switch

2330

Explain ibm infosphere information server and highlight its main features?

1037

How many areas for files does datastage have?

1085

What is a merge?

1078

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2227

Can you explain players in datastage?

1144

Demonstrate experience in maintaining quality process standards?

2459

what is the custome stage in datastage? how can we impliment that one? plz tell me

2318