wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i.
- 1 Answers
- 8400 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 flashback table ? Advance thanks
Explain what are the different versions of informatica?
What is the status code in stored procedure transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is incremental aggregation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is sq transformation?
Explain lookup transformation is active in informatica
What are the main issues while working with flat files as source and as targets ?
How can you validate all mappings in the repository simultaneously?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
is it possible to index the data in cache of lkp transformation ?
tell me the rules and responsblites in our project(my project is development)
what is the size of your data warehousing?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
