if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 20087 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 |
what are testing in a mapping level please give brif eplanation
What is the functionality of update strategy?
How to load a relational source into file taget?
expain about the tune parameters?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
From where we can start or use pmcmd?
What is meant by lookup transformation? Explain the types of lookup transformation?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
What is a predefined event?
what is lookup ?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Teradata 
