In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?
Answers were Sorted based on User's Feedback
Answer / srinivas.medagum
When the records come from SQ each record from first one
checks for the group by port but till last record it doesnot
found .So by default as the last record considered as only
record it stores in Agg T/R.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ankit kansal
By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...
please make me correct if i am wrong..
http://deepinopensource.blogspot.in
Is This Answer Correct ? | 1 Yes | 0 No |
If you're using Aggregator Trasnformation without using group by on any port then the aggreagtor TXNs consider whole table as one group and gives the last row as output.
Why last row as Output : by default aggregator uses MAX() function
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pooja
few options:
1. did you place any other trans before Agg t/r
2. check how many rows are comming form source.
3. run the debuger for more info
Is This Answer Correct ? | 0 Yes | 1 No |
I have source like this 1:2;3. so i want to load the target as 123
Write the different tools in the workflow manager?
Where do you create/define mapping parameter and mapping variable?
How are the sources and targets definitions imported in informatica designer?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
How can informatica be used for an organization?
Why touse stored procedure in ETL Application?
Is there any target staging area in informatica not staging area
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Different circumstance which drives informatica server to expel records?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c