Answer Posted / baiju
When a row enters a transformation, informatica assigns a
rownumber. if this number change for a row, that's an
Active transformation. In other words the nth row comming
IN will go as n'th row, then the transformation is PASSIVE.
Sorter is an active transformation!! IT never changes
the total row count, it changes only the order!!
| Is This Answer Correct ? | 15 Yes | 19 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
define galaxy repository in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
What do you understand by term role-playing dimension?
differences between service based and product based?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
write a query to retrieve the latest records from the table sorted by version(scd)
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What do you understand by SOA of Informatica?
Explain lookup transformation is active in informatica
What is the need of etl tools?
What is powercenter on grid?
Performance tuning in UNIX for informatica mappings?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
