What are active transformations? Name them.
Answer / mahi
Active transformation change the rows that pass through the mapping.
aggregator,filter,sorter,router,source qualifier,transaction control ete.. are active transformations in informatica.
| Is This Answer Correct ? | 0 Yes | 0 No |
EXL informatica Questions
What is Performance tuning in Informatica?
What is workflow monitor?
i have two source data there is no pk,fk how to join the two sources
why union is active transformation?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
what is target update override and when we use it?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is degenerated dimension?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater