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
- 10194 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
client know skid info?
How rejected rows are managed in datastage?
What are stage variables and constants?
What is the difference between informatica and datastage?
What is the difference between datastage and informatica?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between server job and parallel jobs?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
what is flow of project?
root tree will find which is server job and which is parallel job?
What are the different options associated with dsjob command?
What are some different alternative commands associated with "dsjob"?
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to write server Routine coding?
