Answer Posted / sasikumar_bes
A transformation is said to be active when the no. of input
rows to the transformation is not equal to the number of
output rows from the transformation.
input rows != output rows either it can be less or more
when input rows is equal to the output rows then it is
called passive transformation.
| Is This Answer Correct ? | 43 Yes | 11 No |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
As union transformation gives UNION ALL output, how you will get the UNION output?
Why filter transformation is an active one?
r u done any partitions in ur project?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is native users?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is powercenter on grid?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is a filter transformation and why it is an active one?
What differs when we choose the sorted input for aggregator transformation?
What is meant by target load plan?
What is target load order?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance