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
10197 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 are data elements?

1181

What is a datastage job?

1014

explain about citrix scheduling tool in datastage

2462

How many types of stage?

1181

Explain Quality stage?

1162

table actions available in oracle connector?

1614

How we can covert server job to a parallel job?

1153

What is the use of datastage designer?

1159

Describe link sort?

1018

What is difference between join, merge and lookup stage?

1102

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3652

CHANGE CAPTURE

1311

Does datastage support slowly changing dimensions ?

1110

What is the project in datastage?

1116

How will you move hashed file from one location to another location?

2155