if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 20161 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
When the 'Sorted Input' is enabled and if the data is not
sorted, then unexpected results will occur. It means the
session will succeed but the end result may not be the way
as per the business requirement.
Another point to be remembered is:
Group by columns in the Aggregator transformation must be
in the same order as they appear in the Sorter
transformation
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / vaibhav bhandeo
This technique is used when you want a performnce boost.
There will be an aggrigator cache created and will be
indexed. Although you have not given a sorted input it will
still work fine as it is indexed in cache. Please note this
is not like a page fault where you have to bring the page
from the secondary memory when not found in primary memory.
| Is This Answer Correct ? | 1 Yes | 9 No |
Answer / k gopi krishna
Session throws warning. can see it in log file
In case of Join , i guess session fails
| Is This Answer Correct ? | 0 Yes | 8 No |
Is there any target staging area in informatica not staging area
What is Java Transformation? what are the uses of it?
without dynamic lookup transformation how to insert new rows and update existing rows?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
How do you do error handling in Informatica?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
daily how much amount of data send to production?
Useful UNIX commands regular/frequently used
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Mapplets can you use an active transformation in a mapplet,
What is the advantage of informatica?
Teradata 
