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.........?
Answer Posted / 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 |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Write the unconnected lookup syntax?
What does cheating measurement mean?
What are different types of transformations available in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are data-driven sessions?
How to improve the performance of a session using sorter transformation?
What is target designer and target load order?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
As union transformation gives UNION ALL output, how you will get the UNION output?
What is different between the data warehouse and data mart?
can u give example for factless fact table
According to his methodology what all you need before you build a datawarehouse
what is the size of your data warehousing?