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
- 9015 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 does role playing dimension mean?
What is the use of code page?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Reusable transformation and shortcut differences
what are the Methods For Creating Reusable Transformations?
Explain what are the different types of transformation available in informatica.
Explain what are the different versions of informatica?
What can we do to improve the performance of informatica aggregator transformation?
Which are the different editions of informatica powercenter that are available?
Whats the difference between informatica powercenter server, repositoryserver and repository?
how to create user defined function (udf) in informatica
Define update strategy?
What is informatica?
without table how to come first record only in oracle?
