In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Answer Posted / ramu
The column which is used as a key prot in sorter should be
the group by port and check box sorted input in aggregator
t/r properties
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Where are the source flat files kept before running the session?
Partition, what happens if the specified key range is shorter and longer
How to extract sap data using informatica?
What is a sequence generator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
have u done any performance tuning? how u ll do?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
As union transformation gives UNION ALL output, how you will get the UNION output?
wat are deployement groups in informatica, how it will be used for developers
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 ?
What are mapplets?
What is rank transformation?
In how many ways we can create ports?
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 .