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
Enterprise data warehouse your projects phase by phase explain?
Mention some types of transformation?
What is the difference between stop and abort in informatica
explan ur project architecture?
Could you explain what is enterprise data warehouse?
What is the function of aggregator transformation?
What are the designer tools for creating transformations?
Define filter transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is a surrogate key?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Partition, what happens if the specified key range is shorter and longer
What are the components of workflow manager?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab