In aggregator if u enable sorted input what will be the
output and disable sorted wt is output
Answer Posted / suneelkumar.dasari
If u enable the sorted input first of all burden on session will decrease and in sorted order aggregate data will come.
If u disable the sorted input port first first row type aggregate data and second row type aggregate date will come.But session won't fail.
Correct me if i am wrong.
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What could be the possible resons of locks by user?
What is main use of mapplet?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What does role playing dimension mean?
What are multi-group transformations?
what are the deliverables?in your project?
list out all the transformations which use cache?
What is the cumulative sum and moving sum?
What are the reusable transformations?
What do mean by local and global repository?
Can we create a Integration service without a Repository service and vice versa?
Explain the aggregator transformation?
What is olap (on-line analytical processing?
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
What is a sequence generator transformation?