Is sorter an active or passive transformation?What happens if we uncheck the distinct option in sort - Sorter is an active transformation. if you don't check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table. - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: Is sorter an active or passive transformation?What happens if we uncheck the distinct option in sorter.Will it be under active or passive transformation?

Answer: Sorter is an active transformation. if you don't check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table.

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8072 users
Added on	2/23/2013
Views	72981
Rate it!

Question: Is sorter an active or passive transformation?What happens if we uncheck the distinct option in sorter.Will it be under active or passive transformation?

Answer:

Sorter is an active transformation. if you don't check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table. Source: CoolInterview.com

Answered by: nandhini | Date: 6/18/2008 |

Contact nandhini

by default every transformation is passive, after applying any condition or logic then only its becoming like active. Source: CoolInterview.com

Answered by: suresh | Date: 2/10/2010 |

Contact suresh

Active transformation changes no. of rows coming in.
Passive doesnt .

Source: CoolInterview.com

Answered by: sowjanya | Date: 8/16/2010 |

Contact sowjanya

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	This is a scenario in which the source has 2 cols 10 A 10 A 20 C 30 D 40 E 20 C And there should be 2 targets one to show the duplicate values and another target for distinct rows. T1 T2 10 A 10 A 20 C 20 C 30 D Which transformation can be used to load data into target? 40 E	View Answer
	What is the need and when do we use a dynamic lookup cache?	View Answer
	How i can do incremental aggregation in real time?	View Answer
	What is the difference between Informatica 7.0 and 8.0 ?	View Answer
	In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?	View Answer
	On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?	View Answer
	What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?	View Answer
	In a scenario I want to change the dimensions of a table and normalize the renormalized table which transformation can I use?	View Answer
	Why is meant by direct and indirect loading options in sessions?	View Answer
	SCD Mappings are mostly used Unconnected Lookup Transformation. Unconnected Lookup used static Cache only.At this time how can you insert or update date in Target by using static cache?	View Answer
	How many types of dimensions are available in Informatica?	View Answer
	When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files...	View Answer
	1.can u explain one critical mapping? 2.performance issue which one is better? whether connected lookup tranformation or unconnected one?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode