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
- 22131 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 |
wht is cdc?how to use it in creation of mappings?
What is Micro Strategy? Why is it used for?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is meant by query override?
in reporting we add some new objects,how we get the count of the newly added objects to the report
how can u load the data in time dimension?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What aer the out put files that the informatica server creates during the session running?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
which transformation uses cache?
Teradata 
