Interested to Buy Any Domain ? << Click Here >> for more details...
if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 22475 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 |
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
hw cn v elimate dublicate values from lookup without overriding sql?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
can u any challenge your project?
What are the different components of powercenter?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
what is session parameters?
Can anyone please distinguish what is Inner join and Outer join
Can we create out put ports in source qualifier t/r?
Teradata 
