i have data like
sam
ram
sam
raj
ram
I want two targets
trgt1
ram
sam
trgt2
raj
how can i do this in datastage?
- 4 Answers
- 7759 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / cva
take seqfile for loading src then take filter stage and take
two outputs from filter . write condition in filter stage
use where clause=col like 'sam' and col like 'ram' for one
trg and for second also like that.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How do you register plug-ins?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
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 to implement complex jobs in data stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why do we use exception activity in Datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Name the different types of Lookups in Datastage?
How complex jobs are implemented in datstage to improve performance?
What is the process of killing a job in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the difference types of stages?
What are the job parameters?
how to export or import the jobs in .ISX file
What is staging variable?
