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
- 8248 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
Describe stream connector?
What is a datastage job?
What is the method of removing duplicates, without the remove duplicate stage?
Give an idea of system variables.
How do you register plug-ins?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the difference types of stages?
What are the components of ascential data stage?
Terminate Activity
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
client know skid info?
Differentiate between hash file and sequential file?
What is use Array size in datastage
How complex jobs are implemented in datstage to improve performance?
Explain entity, attribute and relationship in datastage?
