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
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
State the difference between an operational datastage and a data warehouse?
What is the difference between passive stage and active stage?
What are datastage sequences?
Differentiate between hash file and sequential file?
What is aggtorec restructure operator?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What can we do with datastage director?
What are the different types of lookups in datastage?
How to manage date conversion in Datastage?
What is the use of datastage director?
Define data aggregation?
What is the difference between operational data stage (ods) and data warehouse?
What is the project in datastage?
What are the different layers in the information server architecture?