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
- 9624 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
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 is merge stage?
why do u need the IOS upgradation in a FC switch
What is the use of hoursfromtime() function in transformer stage in datastage?
Where do you see different stages in the designer?
What is the difference between datastage and informatica?
State the difference between an operational datastage and a data warehouse?
What is the purpose of pivot stage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are data elements?
Describe routines in datastage? Enlist various types of routines.
What is usage analysis in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are routines in datastage? Enlist various types of routines.
What are stage variables?
