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
- 7074 Views
- I also Faced
- E-Mail Answers
Answer Posted / naresh_infa96
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 |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
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 the difference between writing a joiner query in ANSI style and THETA style?
What are ETL Tools?
Which transformation should we use to normalise the COBOL and relational sources?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What does cheating measurement mean?
Explain the scenario which compels informatica server to reject files?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to create Target definition for flat files?
What is an expression transformation in informatica?
How do you load only null records into target?
