Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10405 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
Why we use surrogate key?
Different ways a project can be moved to production ?...example ….export-import and Version control.
State the difference between an operational datastage and a data warehouse?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between odbc and drs stage?
What is active and passive stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Why do you need stage variables?
What is ibm datastage?
why do u need the IOS upgradation in a FC switch
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between server job and parallel jobs?
How do you import and export the datastage jobs?
What are the different kinds of views available in a datastage director?
What are routines in datastage? Enlist various types of routines.
