Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
Answer Posted / saritha
It is Active transformation.
If you configure the Sorter transformation for distinct
output rows, the Mapping Designer configures all ports as
part of the sort key. When the PowerCenter Server runs the
session, it discards duplicate rows compared during the
sort operation.
Is This Answer Correct ? | 36 Yes | 0 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the use of an aggregator cache file?
What is the surrogate key?
What are the static cache and dynamic cache in informatica?
What is olap (on-line analytical processing?
What does command task mean?
What is union transformation in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the transformations that are not supported in mapplet?
I have a flat file, want to reverse the contents of the flat file
What is rank transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How would you copy the content of one repository to another repository?
Does an informatica transformation support only aggregate expressions?
What is meant by lookup transformation? Explain the types of lookup transformation?