Answer Posted / atiric softwares(raja)
An active transformation can change the no. of rows that
passes through it eg: filter transformation passes the rows
from the source to target that which meet the filter condition.
an passive transformation cannot change the rows that which
passes through it eg: an expression transformation that
performs the calculation on the data and passes all the rows
from source to target
| Is This Answer Correct ? | 25 Yes | 2 No |
Post New Answer View All Answers
Explain sessions?
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?
What are the different transaction levels available in transaction control transformation?
Design a mapping to load a target table with the following values from the above source?
What do mean by local and global repository?
Performance tuning( what you did in performance tuning)
Design time, run time. If you don't create parameter what will happen
Briefly define a session task?
what is the difference between informatica6.1 and infomatica7.1
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How you prepared reports for OLAP?
What the difference is between a database, a data warehouse and a data mart?
What do you understand by term role-playing dimension?
Explain the etl program with few examples.
How can we use batches?