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 to generate sequence numbers without using the sequence generator transformation?
State the differences between sql override and lookup override?
What is a surrogate key?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can we store previous session logs?
Why union transformation is an active transformation?
What is a transaction control transformation?
Informatica Checkpoints
can we override a native sql query within informatica? Where do we do it?
Explain the code page compatibility?
Is stop and abort are same in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Mention few power centre client applications with their basic purpose?
server hot-ws270 is connect to Repository B. What does it mean?