Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What is meant by LDAP users?

1290


What is a passive transformation?

1154


What does cheating measurement mean?

1108


What is the session task and command task?

1115


What is a shortcut and copy in Informatica and how two are different with each other?

1241


what is the -ve test case in your project.

2459


What is lookup change?

1110


Why filter transformation is an active one?

1033


How to improve the performance of a session using sorter transformation?

1191


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1338


In which transformation you cannot drag ports into it?

1381


Can anyone tell me the new features in Informatica 9 Version?

2213


Is it possible to create multiple domains on a single Informatica server?

1291


What are connected or unconnected transformations?

1174


how many types of dimensions are available in informatica?

1180