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
How can we delete duplicate rows from flat files?
What is union transformation?
How to elaborate tracing level?
What is domain in terms of informatica?
What is decode in informatica?
What is incremental aggregation?
In informatica workflow manager, how many repositories can be created?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Where can we find the throughput option in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is repository manager?
Explain the tuning lookup transformation - informatica
Quickly characterize reusable change?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?