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?
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
Explain ibm infosphere information server and highlight its main features?
what are the errors,warnings in datastage
Explain how a source file is populated?
How a server job can be converted to a parallel job?
what is the difference between == and eq in UNIX shell scripting?
Difference between in process and inter process?
Have you have ever worked in unix environment and why it is useful in datastage?
Can you define merge?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the flow of loading data into fact & dimensional tables?
Explain entity, attribute and relationship in datastage?
What are the areas of application?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the types of containers in datastage?