Interested to Buy Any Domain ? << Click Here >> for more details...
Input file one has data as shown below
1
2
3
4
5
6
7
8
Input file two has data like
6
7
8
9
10
11
Design a data stage job which will provide me three output files as shown below:
Output 1
6
7
8
Output 2
1
2
3
4
5
Output 3
9
10
11
Let me know your answers
- 4 Answers
- 6532 Views
- IBM, PR3 Systems, I also Faced
- E-Mail Answers
Answer Posted / sant532reddy
Use input file1 as after file and input file2 as before file to a change capture stage. Change capture stage generates change code 0 for 6,7,8 & 1 for 1,2,3,4,5 and 2 for 9,10,11. Use a filter/switch stage after change capture stage to write records to output file1 when change code is 0, to output file2 when change code is 1 and to output file3 when change code is 2.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are data elements?
Is it possible to query a hash file?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to find value from a column in a dataset?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the job parameters?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What can we do with datastage director?
What is the difference between account and directory options ?
CHANGE CAPTURE
What is a ds designer?
How do you reject records in a transformer?
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 many areas for files does datastage have?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
