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...

I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You

Answer Posted / saradhi

Active Transformation means the no of records u got from
source table is filtred by the transformation and got only
few records may or may not at the target table so this an
active transforamtion. example: if u filtered the data by
agreegate function like sum(sal) here u got only one column
as output so its an active.
Passive means the no of records u got from source table is
equal to the target table records even though the
transforamtion is done
example: sal+comm here u got same no of records as source
after filtering also.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how we can load rejected record's at run time?(not through bad files)

2425


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289


I have a flat file, want to reverse the contents of the flat file

1171


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9896


What is a grid in Informatica?

1116


What are the transformations that are not supported in mapplet?

1084


Define Pmrep command?

1110


What are the types of lookup transformation?

1117


Explain constraint based loading in informatica

1152


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1947


Write the different tools in the workflow manager?

1113


What is InformaticaPowerCenter?

1177


What is the advantage of informatica?

1123


What is lookup transformation?

1092


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1144