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 / jayesh
Dont use group by.By default it will give last row.To
override it,use FIRST function.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
lookup transformation with screenshots
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the various types of transformation?
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?
What are the different components of powercenter?
what are the deliverables?in your project?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the size of your data warehousing?
Describe an informatica powercenter?
Explain the different lookup methods used in informatica?
Difference between Target-based loading and constraint-based loading?
What do you mean by enterprise data warehousing?
can u any challenge your project?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.