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
how we can load rejected record's at run time?(not through bad files)
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
I have a flat file, want to reverse the contents of the flat file
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
What is a grid in Informatica?
What are the transformations that are not supported in mapplet?
Define Pmrep command?
What are the types of lookup transformation?
Explain constraint based loading in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Write the different tools in the workflow manager?
What is InformaticaPowerCenter?
What is the advantage of informatica?
What is lookup transformation?
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?