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
- 6582 Views
- IBM, PR3 Systems, I also Faced
- E-Mail Answers
Answer Posted / sant532reddy
seq file1 and file2 as input to change capture stage and then a switch stage with case=0,1,2 (on change code). Case=0 will give 6,7,8. Case=1 will give 1,2,3,4,5 and case=2 will give you 9,10,11
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How you Implemented SCD Type 1 & Type 2 in your project?
What is meta stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is a datastage job?
Terminate Activity
What is ds designer?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Describe routines in datastage? Enlist various types of routines.
What are system variables and sequencers in datastage
What are the types of containers in datastage?
How do you register plug-ins?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the main features of datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Have you used Unstructured data?
