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
What is lookup change?
difference between repository database and repository service?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is InformaticaPowerCenter?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a joiner transformation?
Parameter and variable differences
Enlist few areas or real-time situations where informatica is required.
Explain what is informatica metadata and where is it stored?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Why do we need informatica?
What are the different types of repositories created using informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to call shell scripts from informatica?
What is meant by target load plan?