wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8241 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
difference between informatica 8.1.1 and 8.6
What is data caches/ index caches?
Parameter and variable differences
What could be the possible resons of locks by user?
How to convert multiple rows to single row (multiple columns) in informatica
What is the difference between informatics 7x and 8x and what is latest version?
How can we delete duplicate rows from flat files?
Can we create multiple integration service on single repository?
In how many ways we can create ports?
tell me the rules and responsblites in our project(my project is development)
Enlist some properties of sessions.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are mapplets?
What is meant by pre and post session shell command?
