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
How do you handle two sessions in Informatica
what is the size of your data warehousing?
What are the different components of powercenter?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is dimensional table? Explain the different dimensions.
What are the performance considerations when working with aggregator transformation?
expain about the tune parameters?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is the -ve test case in your project.
What are the differences between oltp and olap?
What is aggregate cache in aggregator transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Why is sorter an active transformation?
What is the status code in stored procedure transformation?