Interested to Buy Any Domain ? << Click Here >> for more details...
wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 9086 Views
- CTS, I also Faced
- E-Mail Answers
Answer / bsgsr
i believe this should work.
1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100
| Is This Answer Correct ? | 5 Yes | 1 No |
What is the difference between unicode & ascii mode data movement in informatica?
Can anyone briefly describe abt audit table loading?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is dimensional table?
What is the difference between informatica 7.0 and 8.0?
What are the different types of olap? Give an example?
what is the flow?
whatis the default data driven operation in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Major difference between SQL override and Lookup Sql override
what is degenerated dimension
What are the features of complex mapping?
Teradata 
