In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
Answer Posted / amedela chandra sekhar
if u enable sorted input option in aggregator with out group
by result is one row for all input records.
If u enable sorted input and group by session will fail.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Differentiate between a database and data warehouse?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is Data Caches size?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the reusable transformation?
What is a difference between complete, stop and abort?
Can you use flat files in Mapplets.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain sql transformation in script mode examples in informatica
What is the difference between source qualifier transformations source filter to filter transformation?
Name the different lookup cache(s)?
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?
While migrating the data from one environment to another environment how would you manage the connections?
What is InformaticaPowerCenter?