if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
Answer Posted / abhinav
hey I am having one answer regarding the same.may be it
will work.
SQ (sql override)(select * from emp1 order by rownum desc)--
>aggregator-->target
thanks
Abhinav
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How can a transformation be made reusable?
What is the commit type if you have a transaction control transformation in the mapping?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the procedure for creating independent data marts from informatica 7.1?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
design of staging area?
What is Session and Batches?
What is a code page?
whats the logic to load the lower level of granularity of data to fact table.
Is stop and abort are same in informatica?
What is data transformation manager process?
What is Index Caches size?
What all join we can perform in LOOKUP transformation?
How does a sorter cache works?
which one is better performance wise joiner or look up