Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
Answer Posted / suchi
Sorter Transformation is passive when the DISTINCT option
is unchecked bcoz it wont change the number of records
passes through it. Once the DISTINCT option is checked it
may change the no of records if the records has duplicates.
| Is This Answer Correct ? | 25 Yes | 14 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
What are different types of transformations available in informatica?
How do you load first and last records into target table?
How do we call shell scripts from informatica?
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?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the difference between writing a joiner query in ANSI style and THETA style?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the complex transformation you used in informatica
What are the mapping parameters and mapping variables?
What is domain in terms of informatica?
What are mapplets? How is it different from a Reusable Transformation?
What is dynamic cache?
Can you use flat files in Mapplets.
Explain sessions. Explain how batches are used to combine executions?