Interested to Buy Any Domain ? << Click Here >> for more details...
I have a input as:
Col
1
1
2
2
3
I want 3 output as:
Output1:
1
1
Output2:
2
2
Output3:
3
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
- 9 Answers
- 13898 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / suneelbabu.etl
can u mention some more input records as well output
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
What are stage variables and constants?
How do y read Sequential file from job control?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the functionalities of link collector?
What is datastage?
Why fact table is in normal form?
How many Key we can define in remove duplicate stage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
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
Define repository tables in datastage?
What is data partitioning?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
in oracle target stage when we use load option and when we use upsert option?
