Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
- 6 Answers
- 14869 Views
- iFlex, Morgan Stanley, I also Faced
- E-Mail Answers
Answer Posted / deepu
I sorter is an Active Transformation,I u check the Distinct
option it will output only the distint rows from the
source .
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Partition, what happens if the specified key range is shorter and longer
Explain what is informatica metadata and where is it stored?
Can you generate sequence numbers without using the sequence generator transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the types of lookup transformation?
Differentiate between reusable transformation and mapplet.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is dimensional table?
What are the components of workflow manager?
What is the benefit of session partitioning?
Write the prerequisite tasks to achieve the session partition?
explain abt ur project architecture?
How many numbers of sessions can one group in batches?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
