Interested to Buy Any Domain ? << Click Here >> for more details...
INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10
input file 'B' contains:
6
7
8
9
10
11
12
13
14
15
Output file 'X' contains:
1
2
3
4
5
Output file 'Y' contains:
6
7
8
9
10
Output file 'Z' contains:
11
12
13
14
15
How can we implement this in a single ds job?
- 11 Answers
- 18258 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / shar
Yes Union of Two Files is a Good idea
but No need of Transformer Stage we can do it in this way:
src1 ,src2 -->Funnel--->Sort--->Filter---->trg1,trg2,trg3
at sort just put allow duplicates=false
&
at filter just give conditions
1. col1>=1 and col1<6 trg1
2. col1>=6 and col1<11 trg2
3. col1>=11 trg3
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are the different types of lookups in datastage?
What are the various kinds of the hash file?
How do you run datastage job from the command line?
Describe the main features of datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Explain connectivity between datastage with datasources?
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
Name the different types of Lookups in Datastage?
Define Job control?
Define Merge?
Differentiate between operational datastage (ods) and data warehouse?
What is the difference between hashfile and sequential file?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the importance of the exception activity in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
