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
- 18599 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 all the types of jobs you developed?
Differentiate between data file and descriptor file?
How do you register plug-ins?
Can you filter data in hashed file?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
I have a few records just I want to store data in to targets cycling way how?
How to RD using transformer?
What are the areas of application?
Whats difference betweeen operational data stage (ods) and data warehouse?
Explain the situation where you have applied SCD in your project?
Difference between server jobs & parallel jobs?
What is active and passive stage?
What is the method of removing duplicates, without the remove duplicate stage?
What are the differences between datastage and informatica?
What are the different layers in the information server architecture?
