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
- 8246 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
Triggers,VIEW,Procedures
what are the errors,warnings in datastage
How do you start developing a datastage project?
Give an idea of system variables.
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the types of containers in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
whom do you report?
What are sequencers?
What are the benefits of datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how can we create rank using datastage?what is the meaning of rank?
What is the different type of jobs in datastage?
Define Routines and their types?
What is staging variable?
