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
Answer Posted / saran
using filter stage we can get output
in filter stage in where clause write condition like this
where sal in(2000,4000,5000) this to one dataset link
and specify reject link to another dataset
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
Define meta stage?
explain about citrix scheduling tool in datastage
Is possible to create skid in dim,fact tables?
What are transforms and what is the differenece between routines and transforms?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
options available in sequence job to run,validate?
What are the primary usages of datastage tool?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do you start developing a datastage project?
What are the different plug-ins stages used in your projects?
EXPLAIN SCD
Can you highlight the main features of ibm infosphere information server?
How a source file is populated?
What are constraints and derivations?