Answer Posted / krishna
a transformation a repository object...which
receives,modifies and passes the data...reusable
trasfermation is a trasformation where it can be used any
number of time in a mapping or in mapplet.
we can creat a reusable transformation in trasformation
developer or we can creat a normal trasformation in mapping
designer and promot it as a reusable transformation by
changing the properties.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can we handle two sessions in informatica?
What is the use of source qualifier?
What are multi-group transformations?
What could be the possible resons of locks by user?
What is InformaticaPowerCenter?
What is a standalone command task?
what is the Default Source Option For Update Strategy Transformation?
What do you mean by enterprise data warehousing?
How will the document be delivered to me?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is meant by active and passive transformation?
How do you change a non-reusable transformation to reusable transformation?
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.
How would you join a node to the already existing domain?
Differentiate between a repository server and a powerhouse?
