I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 8413 Views
- I also Faced
- E-Mail Answers
Answer Posted / chethankumar
take 2sequential files 1 funnel 1 filter 3 targets
1)load the files to sequential files
2)join both the records using funnel
3)in filter go to input tab perform sort enable stable
and in where clause give condition if col<6 one target
col>5 and col<11 second, third col>10
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are routines in datastage?
Define Job control?
How do y read Sequential file from job control?
How a source file is populated?
What is a merge?
What are stage variables and constants?
What is the difference between in process and inter process?
What is active and passive stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the different kinds of views available in a datastage director?
State the difference between an operational datastage and a data warehouse?
What are the types of containers in datastage?
Why do we use link partitioner and link collector in datastage?
How do you schedule or monitoring the job?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
