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 are the tuning techniques you applied during your last project
What are the types of schemas we have in data warehouse.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a stored procedure transformation?
What is the sequence generator transformation in informatica?
What is an active transformation?
What is the sql query overwrite in source qualifier in informatica
How to elaborate tracing level?
What is informatica metadata and where is it stored?
Explain how to import oracle sequence into informatica?
How to join three sources using joiner? Explain though mapping flow.
What do you mean by enterprise data warehousing?
Describe the impact of several join conditions and join order in a joiner transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1