Interested to Buy Any Domain ? << Click Here >> for more details...
Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
- 6 Answers
- 16992 Views
- iFlex, Morgan Stanley, I also Faced
- E-Mail Answers
Answer Posted / saradhi
if we check the box distinct means u are eliminating the
duplicate record.so here if we check the distinct while
sorting its eliminating the duplicate records and after its
sorts so the number of records in target are less compared
to source for that it is calles as active. if we uncheck
this all the records are transforms into target table so it
is passive.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the use of target designer?
generate date / time dimension in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Is stop and abort are same in informatica?
What is meant by lookup transformation?
What is xml source qualifier transformation in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to use pmcmd utility command?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the components of workflow manager?
What is dimensional table? Explain the different dimensions.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Can we override a native sql query within informatica?
