Interested to Buy Any Domain ? << Click Here >> for more details...
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.........?
- 4 Answers
- 6747 Views
- I also Faced
- E-Mail Answers
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 |
Explain sql transformation in script mode examples in informatica
What is partioning?how many types of partinings are there
Define enterprise data warehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
guys which is the best institute in banglore to learn informatica??
What are the settings that you use to configure the joiner transformation?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Why is meant by direct and indirect loading options in sessions?
Explian the connected and unconnected lookup transformation
What is meant by incremental aggregation?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Teradata 
