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
What is Index Caches size?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is rank transformation in informatica
What is primary and backup node?
what are the Methods For Creating Reusable Transformations?
How to join three sources using joiner? Explain though mapping flow.
Define the various join types of joiner transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the types of transformations?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Global and Local shortcuts. Advantages.
What are the components of the workflow manager?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the new features of informatica 9.x developer?