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
- 19093 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
How can one find bugs in job sequence?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between orabulk and bcp stages?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How we can covert server job to a parallel job?
how to sort two columns in single job in datastage.
How do you start developing a datastage project?
Distinguish between informatica & datastage. Which one would you choose and why?
What is difference between join, merge and lookup stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Difference between in process and inter process?
Name the command line functions to import and export the DS jobs?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Is it possible to query a hash file?
Explain usage analysis in datastage?
