Interested to Buy Any Domain ? << Click Here >> for more details...
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?
Please answer below. thank you.
- 4 Answers
- 8601 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / sai
There is no performance difference while aggregation because Order by always comes after Aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean incremental aggregation?
What is the status code in stored procedure transformation?
What are mapplets? How is it different from a Reusable Transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is parallel processing in informatica?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is source qualifier transformation in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Is stop and abort are same in informatica?
Partition, what happens if the specified key range is shorter and longer
How are the sources and targets definitions imported in informatica designer?
Why filter transformation is an active one?
What is a snowflake schema?
