I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You
Answer Posted / murali krishna
Transformations can be active or passive.
- An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition.
- A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
In informatics server which files are created during the session rums?
Performance tuning( what you did in performance tuning)
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is the Default Source Option For Update Strategy Transformation?
What is aggregator transformation in informatica?
How do you load alternate records into different tables through mapping flow?
What is data transformation manager process?
What is a joiner transformation?
What is a passive transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Differentiate between sessions and batches?
What are the different types of olap? Give an example?