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
- 6907 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 |
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
wf dont have integration severances how you can run?
Types of error logs in Informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How to delete duplicate record in Informatica?
explain different levels in pushdown optimization with example?
Teradata 
