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
- 6414 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
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define Merge?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the difference between orabulk and bcp stages?
What are the types of hashed files in data stage
Does datastage support slowly changing dimensions ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What all the types of jobs you developed?
root tree will find which is server job and which is parallel job?
What are system variables and sequencers in datastage
What are some prerequisites for datastage?
How can one find bugs in job sequence?
Define Job control?
what is the use of materialized view?
Notification Activity
