Interested to Buy Any Domain ? << Click Here >> for more details...
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
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 meant by target load plan?
Explain lookup transformation in informatica
What are the new features of informatica 9.x developer?
Which transformation is needed while using the Cobol sources as source definitions?
How to create the source and target database connections in server manager?
design of staging area?
What are the different lookup cache(s)?
What are the new features of Power Center 5.0?
What is the difference between router and filter?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is informatica?
Explain the mapping variable usage example in informatica
Mention few power centre client applications with their basic purpose?
where to store informatica rejected data?
