Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9695 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
How to Remove Duplicate using SQL?
What are some different alternative commands associated with "dsjob"?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do you schedule or monitoring the job?
What is the purpose of interprocessor stage in server jobs?
What are some prerequisites for datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How and where you used hash file?
how to delete one row in target dataset
What is active and passive stage?
What is orabulk stage?
in oracle target stage when we use load option and when we use upsert option?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the sortmerge collector?
Describe the architecture of datastage?
