if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
Answer Posted / deepthi
If u enable the 'sorted I/p'option in AGG tranformation,
power center server assumes that all data is sorted by
group.
If u use sorted i/p and dont use the sorted data session
fails.
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
Informatica Checkpoints
What is the advantage of informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what is mean by complex business rule ?
whats the logic to load the lower level of granularity of data to fact table.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How many dimensions are there in informatica?
Explain the different dimensions.
I have a flat file, want to reverse the contents of the flat file
How can a transformation be made reusable?
Which is the t/r that builts only single cache memory?
How to update a particular record in target with out running whole workflow?